View Full Version : XY Scatter graphs

02-21-2007, 10:11 AM
Hi... In setting up an XY scatter graph I have used a macro (taken from another post) to add the data labels however this macro actual plots the data labels on the chart. I just need to be able to have the labels show up when the particular plot is selected by pointing on the graph. I have tried to hide the data labels through the normal chart options toolbar without success. Can someone please assist.

Secondly, I need to add a 45 degree trendline through the chart.. Any suggestions to accomplish this


05-17-2007, 11:24 AM
I'm no expert but on the 45 degree trendline, if you highlight a particular series of data on your graph and right click, one of the options is "add trendline". What you need is the default. i.e. linear

05-17-2007, 12:48 PM
If you want a line at Y=X, you just need two points, the minimum and the maximum. Set it up like this in a 2x2 cell region:

0 0
1 1

Replace 0 with your minimum value and 1 with your maximum. Copy this range, select the chart, and use Paste Special (Edit menu) to add it as a new series, with categories in the first row. Format the line as desired.

There's no built-in way to make the labels appear when you mouse over a point, but you can make it work with chart events:


If you don't want to program all that, download Tushar Mehta's Chart Hover Labels utility, from http://tushar-mehta.com.