Is it possible to have varying colors on a column chart that does not have a series? I want the color palette to behave like the pie chart where the column changes for each data point. Currently, all of the data points are the same color. Example:Current column chart: bar1 is green, bar2 is green, bar3 is green, etc,Expected column chart: bar1 is green, bar2 is yellow, bar3 is blue

It sounds like you currently have a category group, but no series group.One option you could try is to remove the current category group and instead use that group expression on a newly added series group.HTH,RobertRobert Bruckner http://blogs.msdn.com/robertbruckner This posting is provided "AS IS" with no warranties, and confers no rights.

Yes, I tried that. The problem is I the X Axis labeling isn't working now. The individual bars are now seen as 1 group with 1 name for all bars. Am I missing something here?

Did you ever find a solution to this?