Hide particular category in bar chart

Hi

I have a chart that has an optional Y series grouping, that grouping retrieves 2 categories.

The chart is a simple bar chart but in the Value Y Series I'm putting the Percentile Value Data to show the percentage of each category (for example: Category A 80% Category B 20%)

I need to hide one of the categories but I don't want to modify the % that is showing up in the report. For example I need to show only: Category A 80%.

Any ideas on this???

Thanks

Find more posts tagged with

Comments

pricher

Hi,

I don't know your entire scenario, but would making the category you want to hide the same color as the chart background work for you? Go in the Series Palette and change the color of the series you want to hide. You will also want to make the Series Outline transparent in Value (Y) Series.

Hope this helps,

P.

amjch70

<blockquote class='ipsBlockquote' data-author="'pricher'" data-cid="74872" data-time="1300740299" data-date="21 March 2011 - 01:44 PM">
Hi, 
 
I don't know your entire scenario, but would making the category you want to hide the same color as the chart background work for you? Go in the Series Palette and change the color of the series you want to hide. You will also want to make the Series Outline transparent in Value (Y) Series. 
 
 
Hope this helps, 
 
P. </blockquote>
 
Hi, 
 
I don't think that's gonna work because if I change the color of the category the percentage value is going to show up and I don't want to show up the value of the other category. I only need the percentage value of the category that I want. 
 
Thanks

pricher

Hi,

You probably need some scripting at the chart level. If you can build an example of your expected end result using the sample database, I can take a look.

P.

amjch70

<blockquote class='ipsBlockquote' data-author="'pricher'" data-cid="74928" data-time="1300807377" data-date="22 March 2011 - 08:22 AM">
Hi, 
 
You probably need some scripting at the chart level. If you can build an example of your expected end result using the sample database, I can take a look. 
 
P. </blockquote>
 
Thanks a lot for your support. The rptdesign file shows the data with all the categories, lets say that for example I only need the "1" category that is showing up in the report. 
 
The excel file shows the chart that I need, with only one category. 
 
Thanks.

pricher

Hi,

The design you sent me is for a newer version of BIRT. Can you send me the PDF of that report: I just need to see the chart before the transformation.

amjch70

<blockquote class='ipsBlockquote' data-author="'pricher'" data-cid="74934" data-time="1300819867" data-date="22 March 2011 - 11:51 AM">
Hi, 
 
The design you sent me is for a newer version of BIRT. Can you send me the PDF of that report: I just need to see the chart before the transformation. </blockquote>
 
Hi, 
 
This is the chart in pdf. Thanks in advance.

pricher

Sorry, this might be over my knowledge of the Chart API. I was thinking that if you could get a handle of the categories you want to hide for each series, it would work. But I cannot find a way to do that. Maybe someone else can share that knowledge!

P.

amjch70

<blockquote class='ipsBlockquote' data-author="'pricher'" data-cid="74938" data-time="1300825143" data-date="22 March 2011 - 01:19 PM">
Sorry, this might be over my knowledge of the Chart API. I was thinking that if you could get a handle of the categories you want to hide for each series, it would work. But I cannot find a way to do that. Maybe someone else can share that knowledge! 
 
P. </blockquote>
 
Ok, thanks for trying anyway, I really appreciate it.