Line charts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anne - 19 Dec 2003 08:01 GMT

H
I have a problem with line charts, not the chart as such but I have to put in vertical lines at certain points. My x-axis consists of dates (e.g., May 99, Sep. 99, Jan. 00, May 00 etc.) The y-axis tells the percentages. If I want to put in a vertical line at the Jan. 00 point signalling e.g. a referendum, is there a way Excel can do that? Now I do it manually (the line and the corresponding legend), but it would certainly be easier if Excel could do it for me
Thanks
Ann

Reply to this Message

Debra Dalgleish - 19 Dec 2003 11:13 GMT

Jon Peltier has instructions for adding horizontal or vertical lines to
a chart:

http://www.geocities.com/jonpeltier/Excel/Charts/ComboCharts.html#AddLine

> I have a problem with line charts, not the chart as such but I have to put in vertical lines at certain points. My x-axis consists of dates (e.g., May 99, Sep. 99, Jan. 00, May 00 etc.) The y-axis tells the percentages. If I want to put in a vertical line at the Jan. 00 point signalling e.g. a referendum, is there a way Excel can do that? Now I do it manually (the line and the corresponding legend), but it would certainly be easier if Excel could do it for me.

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message