Timeline with critical date markers

[KM01]

I want to create a chart which shows a series of data inflating over time,
with vertical bars marking critical points in time. These critical dates are
input in individual cells in the spreadsheet, rather than being series. I
don’t want to just ‘draw’ lines and overlay them on the chart because the
critical points will change when the dates change. Any ideas?

 

[Andy Pope]

Hi,

Here is a collection of examples for adding lines to charts.

http://andypope.info/charts/averageline.htm
http://www.tushar-mehta.com/excel/charts/straight_lines/index.html
http://peltiertech.com/Excel/Charts/DummySeries.html#AddLine

Without actually knowing the details of you actual chart I get the
feeling that an extra xy-scatter data series with custom errorbar values
might suit your problem.

Cheers
Andy