Chart Markers

[jameswiltshire]

Hi,

I have a chart which i would like to put some custom marker which will represent the direction and magnitude of the data point. My data is spread across the X axis and has different values of Y. I would like to put an arrow from 0 on the X axis to the Y value to indicate the direction and magnitude of that data point.

I`ve tried doing this using the drawing object but cannot find out the location of the data point on the sheet.

Any ideas on how to do this are most welcome.

Cheers

James

 

[Juan Pablo González]

I think you can do that by just adding a new serie to the chart.

Look here for more information on charts:

http://www.geocities.com/jonpeltier/Excel/index.html