Why is the chart data wrong when I hover over it in Excel 2007?

  • Thread starter Thread starter spearl
  • Start date Start date
S

spearl

In Excel 2007, the line and scatter charts do not display the correct x,y
values when the cursor is hovered over a data point. Excel 2003 displayed
the correct x,y values. Is there a way to correct this problem in the 2007
version?
 
spearl -

"Hover" values are correct for me for both Line and XY Scatter chart types
in Excel 2007 SP2.

To check for SP2, choose Office Button | Excel Options | Resources | About
....

If it's not SP2, to get the updates, choose Office Button | Excel Options |
Resources | Check for Updates

- Mike
http://www.MikeMiddleton.com



NonTechie said:
I have Microsoft Office Excel 2007 (12.0.4518.1014) MSO (12.0.6013.5000)
 
I have SP2 installed and am seeing the same problem. It happens when I set
the Min and Max axis scaling. I have a file that demonstrates the problem, if
someone would like to take a look.
 
Anyone have more on this? I have run into same problem. Data appears to
work correctly in chart, formulas, trendlines, etc. But when hovering mouse
over a data point in chart incorrect info is displayed for some data points.
Using Excel 2007 SP2. Thanks.
 
gelliott said:
Anyone have more on this? I have run into same problem. Data appears to
work correctly in chart, formulas, trendlines, etc. But when hovering mouse
over a data point in chart incorrect info is displayed for some data points.
Using Excel 2007 SP2. Thanks.
 
Back
Top