Activity 9: Pivot Chart & Pivot Table

 How to Make a Pivot Table in Easy Steps:

First, Create Data and Highlight it.


Then, Click "Create Pivot Table" and then choose "New Worksheet" then click "Okay"



Afterwards, Go to the "Pivot Fields" tab and Check the boxes of the Fields
you wish to see in your table. 


Original Copy:


Pivot Table:


How to Create Pivot Chart:

Choose data you wish to Create a chart of and then Highlight it.



Select Chart Type:



 And then Click "Okay" to get your final output.


Original:



Pivot Chart:


Thank you for reading!


Comments

Popular Posts