Yes, there is a way to correct this problem in Excel 2007. This issue is caused by a feature called
"Data Labels" that is turned on by default in Excel 2007. When you hover over a data point, Excel 2007 displays the data label instead of the actual x,y values.
To fix this issue, you can turn off the Data Labels feature by following these steps:
- Click on the chart to select it.
- Click on the "Layout" tab in the ribbon.
- Click on "Data Labels" in the "Labels" group.
- Select "None" from the drop-down menu.
Once you have turned off the Data Labels feature, Excel 2007 will display the correct x,y values when you hover over a data point in a line or scatter chart.