Timeline with critical date markers

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?

Hi,

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

http://andypope.info/charts/averageline.htm
http://www.tushar-mehta.com/excel/ch...nes/index.html
http://peltiertech.com/Excel/Charts/...s.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

KM01 wrote:
> 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, Microsoft MVP - Excel
http://www.andypope.info

Thanks - these are really useful links. Problem solved!

KM