I have a file that has 60 plus data points that I need to manipulate by any combination of of the data, time frames, etc.
I need to be able to select one day, any combination of days, a month, any combination of months, and any combination of the data points to see what's happening in my printshop.
Right now, it's the same chart style, which is VERY BORING. I need different chart styles, colors, types. that best displays the data that's being measured.
I would love for it to be on ONE sheet in order to show the relationship from point to point, but if it must be more than one sheet, then they should be grouped together depending on what they are representing:
Time with time
Dates with dates
Binds with binds
Counters, i.e. meters, page count volumes etc.
The key is that when I push a combination of slicers, all related data points should update to represent whats being requested.
For instance, I would like to see how many jobs Luis Rosa completed on Monday, Weds, and Fridays that were velo binded, and how many color pages vs. b/w pages, etc.
There is a lot of macros in this file and it is liked to another file...I don't think you need the other file as these tables, slicers etc will reside in this file only as ALL of the data created by the user form will remain in this file forever.