Basics of pivot charts:
To give you the ballpark figure; Pivot chart is supposed to be a really valuable feature of Excel. With the help of pivot charts, you can make your presentation not just more attractive but even more convincing. Be it a professional presentation or an academic project, Pivot charts can help gain the attention it deserves.
When it comes to analyze certain data or summarize it, pivot charts are pretty effectual. They present a precise scenario. The fields where pivot charts can yield great results in terms of presenting numerical data in illustrated formats are Sales and Marketing scenarios, financial situations and comparisons, formulas, historical analysis and any other data processing area. Pivot charts can also be pretty effective in presenting formulas in online classes. Pivot table reports present a perfect picture of a sequential process.
Well first things first. Let's take a quick look into how to put a pivot chart into use.
How to create a Pivot Chart?
Create a Pivot Chart by following the steps given below:
- After you have made your pivot table, highlight (select) the same.
2. Go to Insert tab>Charts panel and then Select an appropriate chart. For Example, a 2-d column chart from the Column button.
3. Your chart will be created!
How to make a pivot chart effective?
A few notes on using your pivot chart:
- In the bottom of your chart there are options to change your data displayed in the chart.
- You can re-size your chart to increase focus and attention that the chart attracts.
- While inserting your pivot chart, in the Insert Chart dialogue, you can use the options in the same way as you do while using the dialogue for inserting a normal Chart.
For Example, the option to use and manage pre-defined templates and using a chart style as a default.
How to Move your Pivot Chart?
Just like you moved your normal chart, you could also move a Pivot Chart in an all new separate chart-sheet. How to do this;
- When you hold your chart, on the Excel ribbon you will be able to see a Pivot Chart Tools sub-ribbon besides the title of the Excel workbook.
- Under the Pivot Chart Tools sub-ribbon, go to the Design tab > Location panel > Move Chart Button to open the Move Chart dialogue.
3. In the Move Chart dialogue, choose the option New Sheet.
4. Click OK.
Your Pivot Chart will be moved to an all new sheet named Chart1 by default.
How to Format your Pivot Chart?
Now you know how to move your Pivot Chart. Let's see how we customize and format it now.
If you know your normal charts, you very well know pivot charts as well. Just like your contextual Chart tools sub-ribbon for normal charts, you have the Pivot Chart Tools sub-ribbon with various options to format your chart.
The sub-ribbon has 4 tabs - Design, Layout, Format and Analyse. There are different panels and different buttons in all these four tabs.
For Example, the Design tab has five panels:
- Type: To change the type of chart and to save a chart as template.
- Data: To change the data or switch rows and columns.
- Chart layouts: To change the alignment of labels and heading.
- Chart Styles: To change the color style of the chart.
- Location: To move the chart.
Similarly, you can alter and format gridline, titles of charts, boxes, alignment, graphical representation, font colors, background colors and many other things using the Layout, Format and Analyze tabs.
How to Delete your Pivot Chart?
To delete you can:
Either right click on the Chart and click Delete.
Select your chart by clicking on is boundary and press Delete on your keyboard.
That's all you need to know for your fundamental use of Pivot Charts.