Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » How I can show chart legend series dynamically based on Y series value?
How I can show chart legend series dynamically based on Y series value? [message #554884] Tue, 24 August 2010 15:40 Go to next message
Amy  is currently offline Amy Friend
Messages: 29
Registered: April 2010
Junior Member
Hi,

I created a bar chart to display my stacked graph. I have 6 series for Y-Axis for my 6 plan types .

I use legend to display the 6 plans color. The legend always show my 6 Y-series color and value.

But sometime, the Y serise value only come back for the 4 (plans). I want the legend show series value based on Y serise. If only plan 01, 03 and 06 have values, just show 3 plans color/lable in legend.

Thanks!

Amy
Re: How I can show chart legend series dynamically based on Y series value? [message #554948 is a reply to message #554884] Tue, 24 August 2010 20:42 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Amy,

How does it look when you only have the 3 series with values? Are the
other series null?

Jason

On 8/24/2010 11:40 AM, Amy wrote:
> Hi,
>
> I created a bar chart to display my stacked graph. I have 6 series for
> Y-Axis for my 6 plan types .
> I use legend to display the 6 plans color. The legend always show my 6
> Y-series color and value.
> But sometime, the Y serise value only come back for the 4 (plans). I
> want the legend show series value based on Y serise. If only plan 01, 03
> and 06 have values, just show 3 plans color/lable in legend.
>
> Thanks!
>
> Amy
Re: How I can show chart legend series dynamically based on Y series value? [message #555170 is a reply to message #554948] Wed, 25 August 2010 17:01 Go to previous messageGo to next message
Amy  is currently offline Amy Friend
Messages: 29
Registered: April 2010
Junior Member
Jason,

Thank you for your help!

I use java object pass data to Birt, use script to loop the java object to set up my dataset.

I use table display the data based on dataset and display the data in the Chart.

Here is the table data:

CoverLevel Plan01 Plan02 Plan03 Plan04 Plan05 Plan06

40% - 0 0 0 0 0 0
50% - 4.7 3 5.83 4.97 0 0 0
55% - 6.59 8.04 6.92 0 0 0
60% - 8.18 9.9 8.58 0 0 0
65% - 11.32 13.63 11.87 0 0 0
70%- 14.27 16.97 14.94 0 0 0
75% - 19.37 22.82 20.29 0 0 0

Sorry about the format above. I can't make it better.

X-Axia is the first column, CoverLevel: 40%, 50%....
The Y axis are 6 series plan values based on plan.

Chart display data like stacked graph. 6 plans as a group together, based on coverage level, display the plan values.

If not data for plan, which in this case are Plan 04, 05, 06, all columns are 0. The chart should only see 3 paln in legend.

Below is another table data :

CoverLevel Plan01 Plan02 Plan03 Plan04 Plan05 Plan06
40% - 0 0 0 0 0 0
50% - 4.27 5.1166 4.41 0 0 0
55% - 5.7933 6.89 5.98 0 0 0
60% - 7.04 8.3366 7.2766 0 0 0
65% - 9.5833 11.3133 9.9233 0 0 0
70% - 11.8966 13.8866 12.3166 2.53 10.44 8.24
75% - 15.9866 18.4933 16.56 3.06 14.22 12.18
80% - 0 0 0 4.09 17.28 16.04
85% - 0 0 0 5.24 23.29 21.47
90% - 0 0 0 7.56 30.04 27.23

In this case, I need see 6 plans in legend.

Thanks!

Amy
Re: How I can show chart legend series dynamically based on Y series value? [message #555187 is a reply to message #555170] Wed, 25 August 2010 18:15 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Amy,

Any chance you could put that sample data in a csv and recreate your
chart with a flat file datasource. Create 2 charts one for each set of
sample data. Zip it all up and email it to me at jasonweathersby at
windstream dot net.

Jason

On 8/25/2010 1:01 PM, Amy wrote:
> Jason,
>
> Thank you for your help!
>
> I use java object pass data to Birt, use script to loop the java object
> to set up my dataset.
>
> I use table display the data based on dataset and display the data in
> the Chart.
>
> Here is the table data:
>
> CoverLevel Plan01 Plan02 Plan03 Plan04 Plan05 Plan06
>
> 40% - 0 0 0 0 0 0
> 50% - 4.7 3 5.83 4.97 0 0 0
> 55% - 6.59 8.04 6.92 0 0 0
> 60% - 8.18 9.9 8.58 0 0 0
> 65% - 11.32 13.63 11.87 0 0 0
> 70%- 14.27 16.97 14.94 0 0 0
> 75% - 19.37 22.82 20.29 0 0 0
>
> Sorry about the format above. I can't make it better.
> X-Axia is the first column, CoverLevel: 40%, 50%....
> The Y axis are 6 series plan values based on plan.
>
> Chart display data like stacked graph. 6 plans as a group together,
> based on coverage level, display the plan values.
>
> If not data for plan, which in this case are Plan 04, 05, 06, all
> columns are 0. The chart should only see 3 paln in legend.
>
> Below is another table data :
>
> CoverLevel Plan01 Plan02 Plan03 Plan04 Plan05 Plan06
> 40% - 0 0 0 0 0 0
> 50% - 4.27 5.1166 4.41 0 0 0
> 55% - 5.7933 6.89 5.98 0 0 0
> 60% - 7.04 8.3366 7.2766 0 0 0
> 65% - 9.5833 11.3133 9.9233 0 0 0
> 70% - 11.8966 13.8866 12.3166 2.53 10.44 8.24
> 75% - 15.9866 18.4933 16.56 3.06 14.22 12.18
> 80% - 0 0 0 4.09 17.28 16.04
> 85% - 0 0 0 5.24 23.29 21.47
> 90% - 0 0 0 7.56 30.04 27.23
>
> In this case, I need see 6 plans in legend.
>
> Thanks!
>
> Amy
Re: How I can show chart legend series dynamically based on Y series value? [message #555691 is a reply to message #555187] Fri, 27 August 2010 16:25 Go to previous messageGo to next message
Amy  is currently offline Amy Friend
Messages: 29
Registered: April 2010
Junior Member
Jason,

Thank you so much!

I just sent the files to you by email.

Please let me know if you need more information.

Amy
Re: How I can show chart legend series dynamically based on Y series value? [message #556056 is a reply to message #555691] Mon, 30 August 2010 16:53 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

I replied to your email.

On 8/27/2010 12:25 PM, Amy wrote:
> Jason,
>
> Thank you so much!
>
> I just sent the files to you by email.
>
> Please let me know if you need more information.
>
> Amy
Re: How I can show chart legend series dynamically based on Y series value? [message #1693921 is a reply to message #556056] Wed, 29 April 2015 09:53 Go to previous messageGo to next message
indu K is currently offline indu KFriend
Messages: 2
Registered: September 2013
Junior Member
Hi Jason,
can you please help me for finding solution. i have same kind off problem. I am using Bar chart with 3 series below chart i have to show data like that

Y axis data : india aust uk
series1: 1 1 2
series2: 1.2 1.09 1.65
series3: 4 5 6

Thanks in advance Smile

[Updated on: Wed, 29 April 2015 09:56]

Report message to a moderator

Re: How I can show chart legend series dynamically based on Y series value? [message #1694788 is a reply to message #1693921] Thu, 07 May 2015 21:14 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

Hi Indu,

Can you explain more about what you're wanting to see from this data? None of these have a 0 value, so I'm not understanding how this relates to the issue above. Is it because it's possible that the values for say, UK are 0, 0, and 0 and you won't want to show UK in that case? Let me know.


Michael

Developer Evangelist, Silanis
Previous Topic:Birt report not showing in IE11 - when in iframe
Next Topic:How do I create Temp tables (using Go)
Goto Forum:
  


Current Time: Sat Aug 29 09:29:52 GMT 2015

Powered by FUDForum. Page generated in 0.31993 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software