This may be a simple thing but I can't figure it out (Mac, Excel 2011). I have some numerical data - 10 numbers. I need to make a simple bar graph, such that the first three numbers are grouped together (red bars next to each other), the next two are a next group in blue, the next 3 are another group in green, etc. Somehow, when I add these groups to the Chart Data, it always spreads them out among the groups instead of grouping them together the way I want. What am I missing?
thanks in advance
Bookmarks