How To Create a Pivot Chart Without a Pivot Table in Excel 2013

  • MORE

how to create pivotchart lead 675403

Sometimes you want the flexibility and interactivity of a pivot chart without the hassle of creating a new pivot table. Fortunately, Microsoft Excel 2013 provides exactly that capability. In just a few simple steps, you can create a pivot chart from raw data.

1. Click anywhere inside the data you wish to use for your chart.

how to create pivotchart 1 click data 675403

2. Click the "Insert" tab at the top of the screen.

how to create pivotchart 2 click insert 675403

3. Click "Recommended Charts" or "PivotChart" on the Ribbon.

how to create pivotchart 3 click recommended charts 675403

4. Select a Chart with the PivotChart icon in the upper right corner.

how to create pivotchart 4 click chart 675403

5. Choose filtering options using the interactive controls on the newly created pivot chart. 

how to create pivotchart 5 filter chart 675403

Add a comment
  • Thero Nelson Raditloko Says:

    more information about pivot tables

  • Juan Sombrero Says:


    I noticed a bug in Excel 2013 when creating a pivot chart without pivot table: I can no longer fill a chart title in the formula box, and hence I am not able to create a dynamic chart title (by selecting the title and then enter a formula in the formula box). When I do exactly the same WITH an underlying pivot chart everything works as it should.

    Is this a problem you are familiar to and maybe know a solution to? It's been driving me knuts and I get no answers On any forums.

    Many thx

Back to top