Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I charted the following data in a clustered column chart.
Level 1 Level 2 Level 3 Level 4 FY07 - Total 167 23 20 43 81 FY08 - Total 178 22 40 26 90 These are total department errors segregated by levels for each fiscal year. There are 3 different departments involved. What I did was just total the errors for each FY and each level. Now my boss wants to see how many errors were performed within each level by Dept A, Dept B and Dept C and compare the 2 fiscal years. I hope Im explaining this properly. How can I arrange the raw data so I can chart this? Thank you, Karen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto Arrange Chart Labels | Charts and Charting in Excel | |||
re-arrange cell data | Excel Discussion (Misc queries) | |||
re-arrange data in date order | Excel Worksheet Functions | |||
how to split data into columns and arrange the resulting data | Excel Discussion (Misc queries) | |||
arrange data by criteria | New Users to Excel |