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

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

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

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