Combining Multiple-Color Data Series into One Bar Chart
 

I am trying to create a bar chart that incorporates three sets of data. The
problem: (1) All of the data needs to be ranked (in total) and (2) each of
the data series must be represented by a different color in the bar chart.
How do I accomplish this in Excel 2007?