insert vertical grid line that is linkedto a certain data element
 

Hi.

I have a chart with the performance of certain stocks (x=date, y=value). I
add data to this chart weekly, and plot the year-to-date performance as well.
I would like to add grid lines at the start of each year: a vertical grid
line that is linked to a certain date and moves when additional dates are
added. Also, the number of data points between each vertical grid line is not
fixed: it differs per year.

Anybody has a clue how to get this implemented?

Thanks!

Henk-Jan

insert vertical grid line that is linkedto a certain data element
 

Hi,

You can add vertical lines to line charts or scatter charts, but they are
slightly diffierent techniques.

Please clarify,

--
Thanks,
Shane Devenshire


"Henk-Jan" wrote:

Hi.

I have a chart with the performance of certain stocks (x=date, y=value). I
add data to this chart weekly, and plot the year-to-date performance as well.
I would like to add grid lines at the start of each year: a vertical grid
line that is linked to a certain date and moves when additional dates are
added. Also, the number of data points between each vertical grid line is not
fixed: it differs per year.

Anybody has a clue how to get this implemented?

Thanks!

Henk-Jan

insert vertical grid line that is linkedto a certain data element
 

http://peltiertech.com/Excel/Charts/AddLine.html
http://peltiertech.com/Excel/Charts/...Gridlines.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Henk-Jan" wrote in message
...
Hi.

I have a chart with the performance of certain stocks (x=date, y=value). I
add data to this chart weekly, and plot the year-to-date performance as
well.
I would like to add grid lines at the start of each year: a vertical grid
line that is linked to a certain date and moves when additional dates are
added. Also, the number of data points between each vertical grid line is
not
fixed: it differs per year.

Anybody has a clue how to get this implemented?

Thanks!

Henk-Jan