Okay, I've attached a spreadsheet. I'm having an issue choosing a chart. The data I have is for four regions. In each region I'm doing a count of the number of employees who have a certain ethnicity AND I'm also concerned about particular jobs. So, ideally I'd like a chart that captures *all* the data. So it would show, by region, the counts for people in job 1 who have ethnicity X.
Trouble is, I'm not sure how to set it up at all. I think I might have too many criteria. Ideally I'd like a bar chart or a combo chart, but at this point I'm open to anything.
Does anyone have any suggestions?
I feel like I used up all my brain power in order to create the formulas to get the data and now I have nothing left over to figure out the chart.
Bookmarks