Can draw horizontal AND vertical lines in a combined chart ?

J

Jorge Fonyat

I have a chart with 2 Y axes. One plots 3 lines and the other two.
I managed to place several horizontal lines using the method Jon
Peltier describes in his great site.
Now I need to do something pretty classic: have vertical lines in each
year end of the time series in the X axis.
It simply seems to be impossible.
I suspect it has something to do with the technique used to draw the
horizontal lines.
Any way to make this happen ?
Thanks and regards, Jorge Fonyat
PS: I tried to add the vertical lines using the instructions in Jon
Peltier's site too.
PS2: I think I deleted the secondary X axis using del. Cannot make it
reappear...
 
J

Jon Peltier

Jorge -

You should be able to use my technique to draw lines in both direction
on your chart. Once you draw the first, and get the extra axes set up,
the second one is much easier.

To get back a deleted axis, right click on the chart, go to the Axes
tab, and check the appropriate box. But you must have at least one
series designated as secondary before you can add a secondary axis.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top