Experts:
I need some assistance with creating slicers and pivot table(s) + associated interactive/dynamic graph(s).
Background:
I have some (sample) data -- see attached XLS -- which includes the following data elements:
- 3 Units (USS ABC, USS KLM, USS XYZ) + associated info in columns B and C
- 2 Home Ports (Norfolk, San Diego) across column D
- Year and Month values (columns E and F)
- Categories (Alpha and Bravo) across columns G:J and K:N
- Factors Alpha-1:4 and Factors Bravo-1:4
- Various (random) values in cell range G3:N20
What I Need Some Help With:
- For this data set, one could create multiple graphs to visualize depict the information. As indicated, this is only sample data but my actual data set is much more extensive.
- For instance, the various graphs could include the following:
1. Graph (histogram or pie chart) for "Units" and their associated factor values
2. Graph for "Home Ports" and the # of associated unit counts
3. Graph for "Class Type" and "Factor Count"
4. Graph by Dates (Year/Month)
etc. etc.
- Now, instead of having 5 or 6 or even more (distinct) graphs, I'd like to minimize the # of graphs but dynamically display as much information as possible. For instance, I'd like to use maybe "Pivot Tables" and "Slicers" in order to having both an interactive data selection and dynamic graph.
My question: Based on the provided sample data, could someone please assist me with setting up the "Slicer", "Pivot Table" and "Graph" which will allow for interactive/dynamic visualization of the data set?
Thank you in advance for any assistance in this matter.
EEH
Bookmarks