insert vertical grid line that is linkedto a certain data element

H

Henk-Jan

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
 
S

ShaneDevenshire

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

Odd chart type needed 1
Missing data 1
Plotting a current Date Vertical Line 2
Problem adding vertical marker line to line chart 6
Display Horizontal and Vertical Line In Area Chart (Excel 2007) 1
Excel 2010 - Line Chart with Mulitiple Data Sets 1
Help with area chart - need vertical line added 3
dual y-axis align grid, drop line to y axis, add-ins 1

Top