restricting the drop lines to only a single series

[z.entropic]

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

[Stephen Bullen]

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

[Jon Peltier]

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/
_______


Stephen Bullen wrote:

> 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
>
>

[z.entropic]

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

z.entropic

"Jon Peltier" wrote:

> 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/
> _______
>
>
> Stephen Bullen wrote:
>
> > 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
> >
> >
>