Hi,
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:
> 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
>
>
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Bookmarks