Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Cornwall, UK
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Graphs no longer displaying

    All the graphs in my Excel files have stopped displaying - I now just see the Axes and Gridlines with no data - though it is still linked to the data.
    I'm using Excel 2007 with Vista. As it has happened to new and old files I suspect a MS Update may be the cause. Has anyone any ideas

    Thanks

    Marcus

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Some thoughts:
    Have you filtered or hidden the source data in some way?
    Have you looked at what the chart says the source data is to see if it is correct?

    Steve

  3. #3
    New Lounger
    Join Date
    Dec 2009
    Location
    Cornwall, UK
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Solved but even stranger

    All the data was correctly referenced.
    I found the solution but am baffled as to how it happenned. The file in question tracks revenue & bookings on our campsite and ihncludes a graph of occupancy by type of camping pitch and revenue current and previous year. A version of this file exists for each year 2004 - 2011.
    All of these files had the Axis scale fixed to dates in 2009... (they were previously fixed but to the season dates of the year in question).

    So all these files have changed their axes reference - but only in the last week - and some had not been opened for over a year until now to compare results. All set to 2009. How? Baffled!

    But at least they all display their data again now.

Posting Permissions

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