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
dont 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
dont 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