Excel column chart in more than one color

[robert693]

Hello,

I created a column chart in a spreadsheet. The chart shows data that has names, dates, and amounts for each date. I would like to have each date under each name appear as a different color. The chart wizard will only let me make a chart with only one color. What am I doing wrong? Thank you for your help!!

 

[the_net_2.0]

if you have a dataseries (usually located inside the legend), the chart wizard should have already color coded each series. Frankly, I would get confused if the series data and the y axis timeline were both colored like rainbows...