Excel: Hide Subtotals From Chart in Excel 2013

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Problem: My data has subtotals that cause spikes in the chart.

  1. Charting data with subtotals does not look good.

    Normally, you would create another range with the monthly data and create a chart from that range. But, Excel 2013 introduces the Funnel icon to the right of the chart. Click the Funnel and you can uncheck certain data points.

  2. Remove each Quarter from the chart.

    The result: a monthly chart:

  3. No more spikes.

For more resources for Microsoft Excel