restricting the drop lines to only a single series

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

z.entropic - 17 Aug 2005 18:26 GMT

I have mutiple-series charts, but would like restric the drop lines only to
only one (ususlly the first) plotted data series. However, the drop line
option seems to apply to ALL data series and creates an unreadable mess.

Is there a way to see only what I want, i.e. the drop lines for a selected
series only?

z.entropic

Reply to this Message

Stephen Bullen - 18 Aug 2005 09:21 GMT

Hi Z,

> I have mutiple-series charts, but would like restric the drop lines only to
> only one (ususlly the first) plotted data series. However, the drop line
> option seems to apply to ALL data series and creates an unreadable mess.
>
> Is there a way to see only what I want, i.e. the drop lines for a selected
> series only?

While the 'Drop Lines' check box does, indeed, seem to affect all the series,
you can get the same visual effect for a single series by using custom error
bars:

1. Double-click the series to bring up the Format Series dialog
2. Select the 'Y Error Bars' tab
3. Click in the 'Custom -' box
4. Select the original Y data range for that series.

You should now have lines extending from each data point down to the axis.

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev

Reply to this Message

Jon Peltier - 18 Aug 2005 18:12 GMT

This might be slightly easier:

1. Double-click the series to bring up the Format Series dialog
2. Select the 'Y Error Bars' tab
3. Click on the Minus Display icon
4. Enter 100% for Percentage

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

> Hi Z,
>
[quoted text clipped - 24 lines]
> The most advanced Excel VBA book available
> www.oaltd.co.uk/ProExcelDev

Reply to this Message

z.entropic - 31 Aug 2005 03:04 GMT

Thanks to both Stephen and Jon for their, as usual excellent, advice.

z.entropic

> This might be slightly easier:
>
[quoted text clipped - 39 lines]
> > The most advanced Excel VBA book available
> > www.oaltd.co.uk/ProExcelDev

Reply to this Message