insert vertical grid line that is linkedto a certain data element

G

Guest

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
 
G

Guest

Hi,

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

Please clarify,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Missing data 1
Problem adding vertical marker line to line chart 6
Plotting a current Date Vertical Line 1
Display Horizontal and Vertical Line In Area Chart (Excel 2007) 2
Exel - add vertical line to two axis graph 0
How to add a vertical line to a Line Chart that aleady has 2 Y axi 1
Vertical line in stock chart 1
Excel chart, set a vertical baseline on a certain date 0

Top