Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Opening Excel 97 worksheet in Excel 2007 in compatibiity mode, I can hover
over an existing X-Y chart series and read the proper series name, time, and value of that point. But if I use my macros to delete all the data series, read in new data, and then re-add the series (most settings on Auto), then when I hover over a series and point, it more times than not gives the name of a different series and a different time, and value! It can pick a series point that is over 1 inch away on the screen. If I click on that point, it will display the same wrong series in the formulas window under =SERIES(...). I make sure that I did not have the wrong series pre-selected, just the chart as a whole. Naturally, the series that are added last (the ones "on top") tend to win. Is there a way to reduce the gravitational pull of the series on top back to Excel 97 levels? I tried resizing the lines and markers to be thinner, but this did not help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why is the chart data wrong when I hover over it in Excel 2007? | Charts and Charting in Excel | |||
Embedded Chart Mouse Hover Difference - XL2007 vs XL2003 | Charts and Charting in Excel | |||
Read Chart Point Values When Hover in 2007 | Excel Discussion (Misc queries) | |||
Mouse Hover display | Excel Discussion (Misc queries) | |||
Mouse Sensitivity | Excel Discussion (Misc queries) |