restricting the drop lines to only a single series

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
Click to expand...

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