View Full Version : Excel column chart in more than one color


robert693
09-29-2010, 05:19 AM
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
09-29-2010, 04:17 PM
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...