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

[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?

 

[Mike Middleton]

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

I have Microsoft Office Excel 2007 (12.0.4518.1014) MSO (12.0.6013.5000)

 

[mwoolf]

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.

 

[gelliott]

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.

 

[MikeyM]

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.