Hide a series

  • Thread starter Thread starter Lynn
  • Start date Start date
L

Lynn

I want to hide (not delete) a series on my chart. This is
possible in Lotus 123 but I can't find an equivalent
feature in Excel. Any suggestions?
 
try this:
right click on the series,
format data series
choose "none" for border, are, lines,and\or markers.
I want to hide (not delete) a series on my chart. This is
possible in Lotus 123 but I can't find an equivalent
feature in Excel. Any suggestions?
Click to expand...

--
Gary Klass
(e-mail address removed)
Editor, PSRT-L
4600 Politics and Government
Illinois State University
Normal, Illinois 61790
http://LILT.ILSTU.EDU/gmklass
(309) 438-7852
(fax) 438-7638
The Chart of the Week: http://LILT.ILSTU.EDU/gmklass/cow
 
Thanks Gary...I have already tried this but it doesn't get
rid of the series in the legend. Having to "hide" so many
indivual parts makes it very time consuming to unhide the
series again at a later point. I was hoping there was some
all inclusive hide/unhide feature that I could use. Any
other ideas?
 
In the worksheet, you can hide the row that contains the series data,
and the series won't appear in the chart.

To hide the row, use a filter (Data>Filter>AutoFilter), or right-click
 
Lynn -

To hide the legend entry, click once to select the legend, then again on
the text of the legend you want to delete (not on the legend key, the
marker or colored square) and press the Delete key.

The other option is to hide the column/row containing the data for the
series. By default, Excel doesn't plot hidden cells.

- Jon
 
Thanks Jon.
-----Original Message-----
Lynn -

To hide the legend entry, click once to select the legend, then again on
the text of the legend you want to delete (not on the legend key, the
marker or colored square) and press the Delete key.

The other option is to hide the column/row containing the data for the
series. By default, Excel doesn't plot hidden cells.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______


.
Click to expand...
 
Back
Top