software

Hi,
I have a simple 2-D Line Chart, whose X-Axis, plots 52 points for each
Calendar Year (1 per week).

Is it possible, to place a Drop Line (or something, similar) on Point
52 (and multiples, thereof), to separate each year?

If so, how?

Regards,
Mick2--
mick2
------------------------------------------------------------------------
mick2's Profile: www.excelforum.com/member.php...oamp;userid=24143
View this thread: www.excelforum.com/showthread...hreadid=500522Hi,

You could use error bars for the dropdowns.
Add a column of data that contains the same Y value for any points you
want to have a dropdown. Then double click the line series and on the Y
Error bars set the Custom - range to this new data.

Cheers
Andy

mick2 wrote:
gt; Hi,
gt; I have a simple 2-D Line Chart, whose X-Axis, plots 52 points for each
gt; Calendar Year (1 per week).
gt;
gt; Is it possible, to place a Drop Line (or something, similar) on Point
gt; 52 (and multiples, thereof), to separate each year?
gt;
gt; If so, how?
gt;
gt; Regards,
gt; Mick2
gt;
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info


Thanks Andy.
Mick2--
mick2
------------------------------------------------------------------------
mick2's Profile: www.excelforum.com/member.php...oamp;userid=24143
View this thread: www.excelforum.com/showthread...hreadid=500522
Thanks Andy,
Your suggestion, did precisely what I wanted it to do.
Bonzer!

Regards,
Mick.--
mick2
------------------------------------------------------------------------
mick2's Profile: www.excelforum.com/member.php...oamp;userid=24143
View this thread: www.excelforum.com/showthread...hreadid=500522