Setting Color Palette on Column Chart Plain, No Series Groups
Hi there
Is it possible to set a color palette somehow on a plain column/bar chart with no series group such that the bars don't all appear in one color ?
EDIT: I know =iif(RowNumber(Nothing) mod 2 = 0, "Blue", "CornflowerBlue") works in the background color but it gets complicated with a lot of values along the x axis - is there a simpler way?
Thanks in advance
Josh
Josh Ash
November 2nd, 2011 2:08am
Hi Josh,
Thanks for your post.
Do you mean you want to specify different color for the bars in your chart, if so, you can refer to the link below, which may enlighten you in somewhere:
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/c874cfa6-081d-4549-8536-369842f06283/
Thanks,
Bill Lu
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
November 3rd, 2011 1:05am
Hi Bill
Thanks for that, it does still require code but it's a better solution that simply using the background color expression.
I assume there isn't a way to do this without code.
Thanks again
JoshJosh Ash
November 3rd, 2011 4:18am