I am trying to make a chart that is a combination of stacked and clustered columns. The table the chart will be based on is 12 rows x 5 columns. The column 1 contains month names Jan - Dec and will be the x-axis data. I want to show the data in column 2 and column 3 in a stacked column next to (clustered with) a stacked column of the data in column 4 and column 5 (for a total of 24 columns - 2 for each month). Right now I can get all the data in columns 2-5 stacked together in single columns (12 columns total) or the data in columns 2-5 in clusters of 4 separate columns (48 columns total). How do I tell Excel which column groups to stack and which column groups to cluster?
Thanks,
Thanks,