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

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

Email* (will not be published)
*Indicates required field
Submit Comments

  1. 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

All Product Types Accessories Cars Digital Camcorders Digital Cameras eReaders GPS Laptops MP3 & Video Players Projectors Smartphones Software Storage Tablets / MIDs VoIP Wi-Fi
All Subcategories
All Subcategories All-Purpose Budget Business Desktop Replacement Gaming Multimedia Netbook Nettop Rugged Student Tablet PCs Ultraportable
Acer Alienware Apple Archos ASUS Averatec BenQ CTL Corp. Dell Digital Storm eMachines Emtec Everex Fujitsu GammaTech Gateway General Dynamics Getac Gigabyte Hercules HP HTC iBuyPower Intel Lenovo MSI Nokia Nvidia OCZ OLPC OQO Origin Panasonic Sager Samsung Sony Sylvania Systemax TabletKiosk Toshiba Verizon Viewsonic Viliv VooDoo Workhorse PC ZT Systems
Minimum Rating
Any Rating 4.5 Stars 4.0 Stars 3.5 Stars 3.0 Stars
Screen Size
10 11 12 13 14 15 16 17 18 20 4 5 6 7 8 9
1024x576 1024x600 1024x768 1200X800 1280 x 720 1280x1024 1280x768 1280x800 1366x678 1366x768 1440x1050 1440x900 1600x768 1600x900 1680x1050 1680x945 1920x1080 1920x1200 800x400 800x480
Weight Range
10.1 - 12.0 pounds 12.1 - 14.0 pounds 14.1 - 16.0 pounds 2 lbs 2 pounds and under 2+ lbs 2.1 - 4.0 pounds 4.1 - 6.0 pounds 6.1 - 8.0 pounds 8.1 - 10.0 pounds Over 16 pounds Under 2 pounds
more options