EXERCISE 8: PIVOT TABLE AND PIVOT CHART

 CONTENT:

First I made the content in which I'll make a Pivot table from:

PIVOT TABLE:

After that, I went ahead and made a pivot table...

After that I was able to make multiple looking tables and set them all in an order I wanted.

Examples of those orders are in the pictures below...

INSERTING A SLICER:

After that I went ahead and selected the table to put in a slicer.

INSERTING A PIVOT CHART:

After I inserted the Slicer, It will be easier for me to navigate, so now I could easy make a Chart, by selecting my Pivot table, and clicking on the insert tab, to Pivot Chart...

Now that I have the Chart in, I can customize it to whatever format I like, and below are some examples...

THE FINAL OUTPUT: