Hi All,

I need to add a vertical line to a column / line chart combo where the
secondary axis is already in use.

I have ready through John Peltier's site
(http://peltiertech.com/Excel/Charts/ComboCharts.html) and
specifically the two options he has under the 'Special Effects and
Features' section for adding vertical lines to a chart, but both
require the use of a secondary axis which is then hidden. That is not
an option for me as I am already using that secondary axis.

I am currently using a line object drawn over the top of the chart
object and manually positioned on the chart as per this image:

http://img143.imageshack.us/img143/5...celcombfm9.png

Is there any way to programmatically determine the location that I
would need to put the line object to have it divide between two points
on the x-axis (say, between Nov 2006 and Dec 2006), or to add it to
the chart object itself without losing what is already there?

Thanks,

Alan.
--

The views expressed are my own, and not those of my employer or anyone
else associated with me.

My current valid email address is:



This is valid as is. It is not munged, or altered at all.

It will be valid for AT LEAST one month from the date of this post.

If you are trying to contact me after that time,
it MAY still be valid, but may also have been
deactivated due to spam. If so, and you want
to contact me by email, try searching for a
more recent post by me to find my current
email address.

The following is a (probably!) totally unique
and meaningless string of characters that you
can use to find posts by me in a search engine:

ewygchvboocno43vb674b6nq46tvb