Excel 2013 – Is there a way to turn off a chart series without removing it


This past year I finally switched to Excel2013 from Lotus123. The only task I miss from Lotus (that I can't figure out how to do in Excel) is: when formatting charts and creating copies of charts it was easy in Lotus to turn 'on' or turn 'off' a chart series (when formatting for printing the chart). It seems in Excel I can only add or remove the series permanently. Is there an easier way to visually turn off and on a chart line series without removing it from the select data source menu?

Best Answer

  • In Excel 2013, when you select a chart, three icons appear floating to the right of the chart. The third of these is the filter icon.

    Unfiltered Chart

    Uncheck the box in front of a series and click Apply. The unchecked series will be hidden from the chart. Notice no formatting of other series takes place, because the series isn't removed by hiding any columns of the worksheet; the series is simply filtered out of the chart's view.

    enter image description here

  • Related Question