LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 9
Default Cursor alignment with data points on scatter plot chart is offset

I have noticed that the selection cursor, when hovering over a scatter plot
in the Windows version of Excel (2003 and 2007 versions), will display the
value of the data point the cursor is supposedly pointing at. This is a
handy feature, however, there appears to be a bug that directly impacts
accuracy of measurements taken from charts when using this feature.

I wrote "supposedly," because the data values displayed when hovering the
mouse over a data set in the chart are for a datapoint about 5-8 pixels to
the right, not the one at the tip of the arrow! This is an offset effect
that is peculiar to Excel charts.

I have tried this on several machines with different graphics cards, all
running WIndiows XP SP2 and two versions of Excel (2003 and 2007); all with
the same results. I have also tried it using a freeware utility called MB
Ruler, which provides a loupe to see the cursor hotspot magnified, so you can
see the effect very clearly.

The offset is not there for selecting cells in the worksheet or using other
features of the windows desktop, such as task bar buttons; it only happens
with the Excel charts. It appears that the charts, as displayed on a Windows
machine, are actually the thing that is offset slightly from where the
program thinks they are.

This problem is reportedly not present on the Excel 2004 for the Macintosh.

This problem has been verified to exist with other users and there does not
apper to be a solution for it. Perhaps MS needs to fix it.
--
Bas V

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to add data points to a scatter plot with trend line Samantha Charts and Charting in Excel 3 April 3rd 23 04:16 PM
Scatter plot - Size of data points from spreadsheet value? ferdy Charts and Charting in Excel 2 October 2nd 06 02:32 PM
How do i show duplicate data points on a scatter plot? Mr.Man Charts and Charting in Excel 2 January 30th 06 03:00 PM
How do I make my data points not overlap in a scatter plot? sfdc Charts and Charting in Excel 2 January 30th 06 03:31 AM
How do I have unique data labels for points in a XY Scatter plot? heyhowzitgoin Charts and Charting in Excel 1 January 18th 06 03:33 PM


All times are GMT +1. The time now is 06:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"