+ Reply to Thread
Results 1 to 7 of 7

Require additional Average value in graph of data

  1. #1
    Forum Contributor
    Join Date
    11-13-2007
    Location
    Petersfield, Hampshire, UK
    MS-Off Ver
    MS Office for Mac ver 16
    Posts
    135

    Require additional Average value in graph of data

    I have 3 sets of data which I display in one line graph successfully (vertical number and horizontal date). I would like to add an average line for each set of data to the graph. I already have cells which calculate this average. Is it possible to add these average lines for each set of data?
    Geoff Culbertson
    Petersfield, UK

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    26,601

    Re: Require additional Average value in graph of data

    Yes,

    Just copy the average down the same number of rows as the series you are averaging and then plot this as a new series.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    11-13-2007
    Location
    Petersfield, Hampshire, UK
    MS-Off Ver
    MS Office for Mac ver 16
    Posts
    135

    Re: Require additional Average value in graph of data

    Hi Richard,
    Thanks for your reply. I have succeeded in adding the average line for each of 3 sets of data in one graph,but I'm not sure whether I have done it in the best way. I added 3 extra rows of data and then copied the average reading into the whole line for that average. I'm also not sure whether it is the same as you have described! Your suggestion made me think in a different way to work it out successfully, so thanks very much.
    Regards

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    26,601

    Re: Require additional Average value in graph of data

    Great. Glad it prompted a solution for you. Should you have any further difficulties upload the workbook.

  5. #5
    Registered User
    Join Date
    03-20-2019
    Location
    Houston,Texas
    MS-Off Ver
    office 365
    Posts
    4

    Re: Require additional Average value in graph of data

    Just copy the average down the same number of rows as the series you are averaging and then plot this as a new series.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Office 365 (Win 10 - Work) & Office 365 Subscription Insider (Win 10 - Home)
    Posts
    39,510

    Re: Require additional Average value in graph of data

    Alfred - you see, to be responding to very old threads. If you have a question of your own, please start your own thread.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  7. #7
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    26,601

    Re: Require additional Average value in graph of data

    Quote Originally Posted by AliGW View Post
    Alfred - you see, to be responding to very old threads. If you have a question of your own, please start your own thread.
    ...and more than a response, an exact echo....

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Require a formula to average a certain number of cells dependent on another cell
    By zimmerlong in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-05-2015, 08:37 PM
  2. [SOLVED] Array Average Formula with one additional criterion
    By hokkaido19 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-12-2015, 04:23 AM
  3. monthly average graph made from daily entry data
    By rodgerdooter in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 07-10-2015, 02:50 AM
  4. [SOLVED] Graph Will Not Show Additional Months Data?
    By garrett.grillo in forum Excel General
    Replies: 8
    Last Post: 03-26-2014, 01:25 AM
  5. Require Bars in graph to maintain the same width
    By Priyadharsini in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-12-2012, 07:18 AM
  6. weighted average getting messed with additional rows.
    By StuartDrury in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-19-2011, 09:52 AM
  7. Replies: 2
    Last Post: 01-07-2007, 11:51 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1