Home
%3CLINGO-SUB%20id%3D%22lingo-sub-613671%22%20slang%3D%22en-US%22%3EInsert%20PivotChart%20is%20available%20in%20Excel%20for%20the%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-613671%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ENow%20you%20can%20create%20visual%20PivotCharts%20in%20%3C%2FSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Foffice.live.com%2Fstart%2FExcel.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSTRONG%3EExcel%20Online%3C%2FSTRONG%3E%3C%2FA%3E%3CSTRONG%3E!%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPivotChart%20insertion%20was%20a%3CFONT%20size%3D%223%22%3Esked%20by%20m%3C%2FFONT%3Eany%20customers%20in%20Excel%20Community.%3CBR%20%2F%3EWe%20listened%20to%20your%20feedback%20and%20provided%20the%20ability%20to%20visualize%20the%20data%20in%20PivotTables%20through%20PivotCharts.%3CBR%20%2F%3EJust%20like%20in%20Excel%20Desktop%2C%20now%20you%20can%20create%20your%20own%20PivotCharts%20and%20edit%20them%20in%20Excel%20web%20app.%3C%2FP%3E%0A%3CP%3ETo%20learn%20more%20about%20PivotCharts%2C%20take%20a%20look%20on%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcreate-a-pivotchart-c1b1e057-6990-4c38-b52b-8255538e7b1c%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ethe%20relevant%20page%20of%20Office%20Support.%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20800px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F114290i1774B3A773855491%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22800_Device.png%22%20title%3D%22800_Device.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%225%22%3EHow%20to%20get%20started%3F%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3E%3CSTRONG%3EGo%20to%20the%20PivotTable%20you%E2%80%99d%20like%20to%20visualize%2C%20or%20insert%20a%20new%20PivotTable.%3CBR%20%2F%3E%3C%2FSTRONG%3EFor%20more%20information%20about%20Insert%20PivotTable%20in%20Excel%20Online%2C%20%3CA%20style%3D%22font-family%3A%20inherit%3B%20background-color%3A%20%23ffffff%3B%22%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel-Blog%2FInsert-new-Pivot-Tables-in-Excel-Online%2Fba-p%2F167548%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3Eclick%20here%3C%2FA%3E%3CSPAN%20style%3D%22font-family%3A%20inherit%3B%22%3E.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLI%3E%0A%3CLI%3ESelect%20a%20cell%20in%20your%20PivotTable.%20%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F114281iB3BD650D2F8DAB65%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22blog1.png%22%20title%3D%22blog1.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLI%3E%0A%3CLI%3ESelect%20%3CEM%3EInsert%20Tab%3C%2FEM%3E%2C%20click%20on%20one%20of%20the%20chart%20buttons%20and%20choose%20your%20PivotChart%20type.%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F114282iBB742557B862CDAA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22blog2.png%22%20title%3D%22blog2.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLI%3E%0A%3CLI%3ENew%20PivotChart%20will%20be%20right%20on%20your%20grid!%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F114283i1BC592415EB214EA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22blog3.png%22%20title%3D%22blog3.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%225%22%3ENow%20what%3F%3C%2FFONT%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ETry%20the%20edit%20options%20on%20%3CEM%3EChart%20Tools%3C%2FEM%3E%20contextual%20tab%20for%20editing%20titles%2C%20legend%2C%20labels%2C%20axes%20or%20gridlines.%20%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F114284iA64588814917992B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22blog4.png%22%20title%3D%22blog4.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLI%3E%0A%3CLI%3ENow%20you%20can%20edit%20your%20PivotTable%20fields.%20The%20changes%20will%20be%20reflected%20immediately%20on%20the%20interactive%20PivotChart.%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F114285iE334F765BFD74E25%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22blog5.png%22%20title%3D%22blog5.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLI%3E%0A%3CLI%3EYou%20can%20change%20the%20chart%20type%20for%20getting%20another%20point%20of%20view.%20Select%20the%20PivotChart%20and%20choose%20one%20of%20the%20other%20chart%20buttons.%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F114286iE7976C80805DF40B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22blog6.png%22%20title%3D%22blog6.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EDon%E2%80%99t%20forget%20to%20share%20your%20feedback%20with%20us!%3C%2FSTRONG%3E%3CBR%20%2F%3EClick%20on%20%3CEM%3EHelp%20Improve%20Office%3C%2FEM%3E%20at%20the%20bottom%20left%20corner%20and%20tell%20us%20what%20you%20think%20about%20PivotChart%20and%20the%20total%20experience%20of%20Excel%20Online.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%225%22%3EExcel%20Online%20is%20rapidly%20growing!%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWith%20tens%20of%20new%20features%2C%20Excel%20web%20app%20is%20more%20powerful%20than%20ever.%3CBR%20%2F%3EInsert%20Pivot%20Chart%20is%20only%20one%20of%20the%20new%20abilities%20added%20recently%20to%20our%20web%20app%20following%20customer%20requests.%3C%2FP%3E%0A%3CP%3EWant%20to%20follow%20up%20our%20roadmap%3F%3CBR%20%2F%3ECheck%20out%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fwhat-s-new-in-excel-online-f8f98d6b-4752-4119-a2aa-4de22ece8d81%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EExcel%20Online%20support%20homepage%3C%2FA%3E%20for%20discovering%20what%E2%80%99s%20new%20and%20what%E2%80%99s%20about%20to%20come%20soon.%20This%20page%20gathers%20all%20the%20useful%20resources%20you%20need%20for%20becoming%20Excel%20Online%20expert!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-613671%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20listened%20to%20your%20feedback%20and%20provided%20the%20ability%20to%20visualize%20the%20data%20in%20PivotTables%20through%20PivotCharts.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-613671%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBlog%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPivotChart%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-615127%22%20slang%3D%22en-US%22%3ERe%3A%20Insert%20PivotChart%20is%20available%20in%20Excel%20for%20the%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-615127%22%20slang%3D%22en-US%22%3E%3CP%3EGreat%20stuff%20Excel%20Team!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-739588%22%20slang%3D%22en-US%22%3ERe%3A%20Insert%20PivotChart%20is%20available%20in%20Excel%20for%20the%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-739588%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20a%20lot%20for%20this%20great%20feature%20!%20Keep%20the%20good%20work%2C%20Excel%20Team%20%3B)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

 

Now you can create visual PivotCharts in Excel Online!

 

PivotChart insertion was asked by many customers in Excel Community.
We listened to your feedback and provided the ability to visualize the data in PivotTables through PivotCharts.
Just like in Excel Desktop, now you can create your own PivotCharts and edit them in Excel web app.

To learn more about PivotCharts, take a look on the relevant page of Office Support.

 

800_Device.png

 

How to get started?

 

  1. Go to the PivotTable you’d like to visualize, or insert a new PivotTable.
    For more information about Insert PivotTable in Excel Online, click here.

  2. Select a cell in your PivotTable.
    blog1.png

  3. Select Insert Tab, click on one of the chart buttons and choose your PivotChart type.
    blog2.png

  4. New PivotChart will be right on your grid!
    blog3.png

 

Now what?

  • Try the edit options on Chart Tools contextual tab for editing titles, legend, labels, axes or gridlines.
    blog4.png

  • Now you can edit your PivotTable fields. The changes will be reflected immediately on the interactive PivotChart.
    blog5.png

  • You can change the chart type for getting another point of view. Select the PivotChart and choose one of the other chart buttons.
    blog6.png

 

Don’t forget to share your feedback with us!
Click on Help Improve Office at the bottom left corner and tell us what you think about PivotChart and the total experience of Excel Online.

 

 

Excel Online is rapidly growing!

 

With tens of new features, Excel web app is more powerful than ever.
Insert Pivot Chart is only one of the new abilities added recently to our web app following customer requests.

Want to follow up our roadmap?
Check out Excel Online support homepage for discovering what’s new and what’s about to come soon. This page gathers all the useful resources you need for becoming Excel Online expert!

2 Comments

Great stuff Excel Team!

Visitor

Thanks a lot for this great feature ! Keep the good work, Excel Team ;)