Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
Vertical line isn't vertical! | Charts and Charting in Excel | |||
Vertical line isn't vertical! | Excel Discussion (Misc queries) | |||
Insert a vertical line on a chart? | Charts and Charting in Excel | |||
How can I insert a vertical column break between data to create a. | Excel Worksheet Functions |