+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Change chart source data in XL2007

  1. #1
    Registered User
    Join Date
    12-30-2009
    Location
    Sydney Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Change chart source data in XL2007

    Thanks in advance for any replies.
    I have charts in a rather complex spreadsheet comprising 12 tabs in total, but the chart itself is quite simple. It originated in XL2003 but simply charts values on the vertical axis against dates on the horizontal axis. Having now come to the end of 2009, I want to continue tracking the values into 2010. The source data is on another worksheet which extends as far into the future as a I want. I have successfully updated the source data by editing in the "select data source" tab which now reflects the correct data source up to 30/6/2010. However, the chart itself refuses to change at all. it continues to chart only up 31/12/2009. XL2003 allowed formatting of the horizontal axis itself but 2007 doesn't seem to offer that function. I have no idea where to go from here. Any suggestions would be most appreciated.

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,363

    Re: Changing chart source data in XL2007

    Hi, have you tried to click the horizontal axis, then on the Chart Tools - Format ribbon click Format Selection and set the minimum and maximum values for the axis?

  3. #3
    Registered User
    Join Date
    12-30-2009
    Location
    Sydney Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Change chart source data in XL2007

    Thank you Teylyn, A bit unintuitive but I eventually found the command you refer to. Problem fixed. Happy New Year and thanks so much

+ 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