+ Reply to Thread
Results 1 to 2 of 2

adding data over existing chart

  1. #1
    Registered User
    Join Date
    01-19-2010
    Location
    Sutton, Quebec, Canada
    MS-Off Ver
    office 2007
    Posts
    37

    adding data over existing chart

    Hi, What I need to do is to add data ( preferably in the form of markers with a linking line (smooth curved) over the bar graph already there.

    In the attached workbook, there is a worksheet called test. In there is the progressive work for this chart table.

    The graph represents the score in percentage of the player's accomplishment every weeks.

    What I would like to do is superimpose group average data over the existing table without affecting it. So the player can visually do a quick scan of his standing vs group average.

    The group average is located in the Graph Data page under B31 to AF31.

    Should be easy for most of you but I'm racking my brains and trying all kinds of stuff but cannot get it to work.

    Need help badly on this . . .

    Mike.
    Attached Files Attached Files
    Mike, (office 2007)

    what kind of key opens a banana ?

    A Monkey !!!!!!!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,925

    Re: adding data over existing chart

    You can plot the line in the same chart as an xy-scatter. Although you will need to use a normal bar chart and not the 3d version.

    You will also need to change the average line formula so the returned information is not text but a true value. You can use a custom number format to display zero.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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