I am trying to add a chart that should summarize the all the data into one chart, doesn't matter which type. I tried adding a pivot chart to see how everything can be best captured so all the information in on one chart. But either chart is becoming to small to read or data is not generating in a meaningful way.
Basically to show total % time spent by each department and by each Group for each Job. Horizontal axis preferably be Department if possible. Not sure if I can add time spent % as secondary axis element or something?
Any help will be highly appreciated.
Thanks,
Rae
Bookmarks