Make Pivot Chart In Excel Hindi
A Pivot Chart can help you make sense of this data. While a Pivot Chart shows data series, categories, and chart axes the same way a standard chart does, it also gives you interactive filtering controls right on the chart so you can quickly analyze a subset of your data.
Steps to create Pivot Chart
For worksheet data, you can create a Pivot Chart without creating a PivotTable first. You can even create a PivotChart that is recommended for your data. Excel will then automatically create a coupled Pivot Table. Here’s how:
Click anywhere in the data.
On the Insert tab, in the Charts group, pick Recommended Charts.
Recommended Charts button on the Insert tab
On the Recommended Charts tab, pick any chart with the PivotChart icon PivotChart indicator button in the top corner. A preview of your PivotChart appears in the Preview pane.
Insert Chart dialog box showing recommended PivotCharts
Once you find the PivotChart you like, click OK.
Note: If you don’t find a PivotChart you like, click PivotChart on the Insert tab instead of Recommended Charts.
In the PivotChart that appears, click any interactive control, and then pick the sort or filtering options you want.
Filter and sort options for a PivotChart
Tip: To remove a PivotChart you no longer want, select it, and then press Delete.
To watch more videos and download the files visit http://www.myelesson.org
To Buy The Full Excel Course visit . http://www.myelesson.org/product or call 9752003788
Connect with us on Facebook - https://www.facebook.com/excelmadeasy/
Connect with us on Twitter - https://twitter.com/Excelmadeasy
No comments:
Post a Comment