+ 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 - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    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

    RIP - d. 06/10/2022

    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 - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,374

    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!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  7. #7
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    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