Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a bar chart with data for different months. Previously the months were different colors on the bar chart (January was blue, February was red, etc). I added a line to my chart to show some different data and now all the months are blue. Is there a way to have the bars be multi-colored while still having the line?
Can you share your sample FILE or sample Data?
UPDATE : I think you are talking about COMBO Chart...
Can you share your sample FILE or sample Data?
UPDATE : I think you are talking about COMBO Chart...
Hi Manish,
May be he is looking for multi-colour option in Combo Chart. If we add only one expression( presentation Bar) then it was shows different colour in each bar but once we add one more expression (Presenation Line) then all the Bar now showing to similar color only.
May be multi-color for bar is not possible in combo chart when we add more then one expression.
Please suggest.
Hi Manish,
I follow your link and got the result. Thank you for sharing.
Michael
You need to put expression in Background Colour. Replace 'City' with your Dimention name.
Hi ,
If you are using one dimension then check on Multicolored other wise check Persistent colors as shown in the image
Regards
Kumar
This has changed it so that there are colors but still not quite what I want. With this code each city is a different color. What I need is for each month to be a different color. January will be blue for every city, February will be red for each city, etc.
Also I have two dimensions, the second on is a drill down.
Thanks
Hi Michael,
If you want specific color for each field then use below expression:
if(FieldIndex('Month',Month)=3,Green(),
if(FieldIndex('Month',Month)=1,Blue(),
if(FieldIndex('Month',Month)=2,Red(),)))
in the same under background color. Replace month with your dimension name.