This question is locked. New answers and comments are not allowed.
Hi,
I'm just trailing the MVC tools to see if I can spike out some charts that we require before purchasing a license. What we would like to do is essentially create a chart where we only have one series with three values which has these values and category names:
FEB: $40000
MAR: $45000
APR: $30000
We then want to color the bars depending on the value. So for example if the value is under 35k we want it to be red, if under 40k blue and if over 40k green. I haven't been able to find a way to do this yet.
One way I've been able to achieve something similar to what I want is to create 3 separate series with only a single value in each. The downside of this though is that then I have to use a legend to show what each column represents and if I have two red columns you won't be able to tell which is which (it isn't just months we want to label, but also categories of items).
Any help would be much appreciated.
Cheers,
Caleb
I'm just trailing the MVC tools to see if I can spike out some charts that we require before purchasing a license. What we would like to do is essentially create a chart where we only have one series with three values which has these values and category names:
FEB: $40000
MAR: $45000
APR: $30000
We then want to color the bars depending on the value. So for example if the value is under 35k we want it to be red, if under 40k blue and if over 40k green. I haven't been able to find a way to do this yet.
One way I've been able to achieve something similar to what I want is to create 3 separate series with only a single value in each. The downside of this though is that then I have to use a legend to show what each column represents and if I have two red columns you won't be able to tell which is which (it isn't just months we want to label, but also categories of items).
Any help would be much appreciated.
Cheers,
Caleb