Colored bars in BAR Chart

[aravinth_anandhan]

Hi all,

I want to display a bar chart which is having different colored bars. For example, i am now using equipment wise bar chart, if i am having 50 equipments, all 50 equipments should be displayed in different colors in bar chart. Now i am getting output for those 50 equipments having same color. I tried by giving that equipment column in DATA MAPPING -

---

> LABEL COLUMNS, I got only 32 bars which is in different colors in output. Kindly give me some solution for this.

thanks in advance

[swapnil_mohite · Accepted solution]

Dear Aravinth,

As per my knowledge, there are only 32 columns in bar chart. If your requirement is changing dynamically u can manage it either by JS in code or through query templates.

Give Points if found useful.

Regards,

Swapnil

[Madhava_M · Accepted solution]

HI Aravinth

You can go to Data Series Details and select the ID and you can change the color it. but one constraints is you can have only for 32 tags in that...

[aravinth_anandhan · Accepted solution]

Hi,

Currently i am having more than 32 bars in my chart, so my query is, after 32 bars can i able to repeat those colors from start?

[jcgood25 · Accepted solution]

You may have more than 32 bars but they will be the same data series and therefore the same color. For separate colors the limit is 32 (I think you'll see that pens 17-32 repeat the colors from pen 1-16 in the default template).

It sounds like your best bet is using ValueColumn for your numerical field and then LabelColumn for the string name field. This way, depending upon the results returned it will provide good coloration between bars, but it may also be decreasingly relevant beyond the first 'x' items. A normal Pareto chart might use the notion of top 10 or top 20, which would be well within the 32 color limit.

[aravinth_anandhan · Accepted solution]

Hi Jeremy,

My label column and value column both are more than 32 records, is there any other way to make all bars to display in different colors? And if pen limit is 32, cant we able to repeat from start (looping) for rest of the bars?

[Former Member]

Hi Aravind,

As per my knowledge we can add upto 32 columns in a bar chart. To display all 50 equipment's in one bar chart is not possible.

Generate 2 query templates, such that each query template gives 25 equipment's. You can generate 2 display templates based on query template, of bar chart having 25 equipment's in different color.

Hope it helps.

Thanks

Rajesh.S

[aravinth_anandhan]

Hi Rajesh,

Now i am getting more than 32 equipments in output, but is same color. But i want those bars to be displayed in different colors.

I tried In ichart, under Data mapping----->Label Columns, i add my Equipment field which is having more than 32 equipments. It is giving only 32 bars in different colours and rest of the equipments are not displayed.

Regards,

Aravinth

[Former Member]

Yes Aravinth,

You can't see bars after 32, even if you go to "Data Series Details" you have a drop down "Data Series ID" where you can see values from 1 - 32.

May be you can try adding more pen's through "Add Data Series" in "Color Context" tab.

Thanks

Rajesh.S

[aravinth_anandhan]

Hi Rahesh,

one more thing, my equipments ll change dynamically. Some time it ll be less than 32 or some times it ll be more.

[aravinth_anandhan]

Hi Rajesh,

In Colour context also having only 31 pens.

Edited by: Aravinth Anandhan on Dec 8, 2011 10:37 AM