Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Recreate excel xy graph
Recreate excel xy graph [message #953708] Mon, 22 October 2012 13:19 Go to next message
Nigel Daniels is currently offline Nigel DanielsFriend
Messages: 66
Registered: July 2009
Member
Hi,

I was able to create the graph pictured in the attachment graph.png
(I've also attached the spreadsheet I used so you can see how this was
constructed). However have struggled to figure out how I do the same
thing in BIRT. All my attempts to create this have failed as BIRT seems
to be built on the assumption that one of the axies is based on grouped
information.

If any one can recreate this in BIRT and show me how it is done I'd be
very grateful as my amateur attempts have failed.

Best regards,

Nigel
Re: Recreate excel xy graph [message #954377 is a reply to message #953708] Tue, 23 October 2012 01:00 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1684
Registered: July 2009
Senior Member

If you can merge your data, so that you have it like:

X | Y | Series
50 | 0 | A
50 | 100 | A
0 | 0 | B
100 | 80 | B
0 | 0 | C
etc...

You could use X for the X axis, Y for the Y axis, and Series for the optional grouping, you should get what you're wanting. Just make sure you deselect the "is category axis" check box, in the x-axis section of the format chart tab. Let me know if you run into issues.


Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Recreate excel xy graph [message #957644 is a reply to message #954377] Thu, 25 October 2012 11:33 Go to previous messageGo to next message
Nigel Daniels is currently offline Nigel DanielsFriend
Messages: 66
Registered: July 2009
Member
Hi Michael,

this approach has got me closer than before, thanks! Looks like the 'is
category axis' was what I needed to drop. However the output I get is
still not what I was expecting but I'm not sure why not.

My data is in a CVS as you suggested:

Series,X,Y
A,50,0
A,50,100
B,0,0
B,100,80
C,0,0
C,10,10
C,20,15
C,25,30
....

I used X for the x-axis, and Y for the y-axis, and Series for an
optional grouping. But my chart looks odd. Series A plots as a single
point, Series B seems correct, Series C looks ok but the first and last
points in the series are connected.

I've put everything in an attached project if it helps to see what is
going on.

Best regards,

Nigel



On 23/10/2012 02:00, Michael Williams wrote:
> If you can merge your data, so that you have it like:
>
> X | Y | Series
> 50 | 0 | A
> 50 | 100 | A
> 0 | 0 | B
> 100 | 80 | B
> 0 | 0 | C
> etc...
>
> You could use X for the X axis, Y for the Y axis, and Series for the
> optional grouping, you should get what you're wanting. Just make sure
> you deselect the "is category axis" check box, in the x-axis section of
> the format chart tab. Let me know if you run into issues.
Re: Recreate excel xy graph [message #957862 is a reply to message #957644] Thu, 25 October 2012 14:51 Go to previous messageGo to next message
Nigel Daniels is currently offline Nigel DanielsFriend
Messages: 66
Registered: July 2009
Member
Hi,

made a discovery looking around the chart gui that grouping was enabled
on the X axis data set under chart data. Now I get a result much close
to what I am seeking, apart from it now seems to ignore the sequence of
the C data series. See the attached image!

Nigel

On 25/10/2012 12:33, Nigel Daniels wrote:
> Hi Michael,
>
> this approach has got me closer than before, thanks! Looks like the 'is
> category axis' was what I needed to drop. However the output I get is
> still not what I was expecting but I'm not sure why not.
>
> My data is in a CVS as you suggested:
>
> Series,X,Y
> A,50,0
> A,50,100
> B,0,0
> B,100,80
> C,0,0
> C,10,10
> C,20,15
> C,25,30
> ...
>
> I used X for the x-axis, and Y for the y-axis, and Series for an
> optional grouping. But my chart looks odd. Series A plots as a single
> point, Series B seems correct, Series C looks ok but the first and last
> points in the series are connected.
>
> I've put everything in an attached project if it helps to see what is
> going on.
>
> Best regards,
>
> Nigel
>
>
>
> On 23/10/2012 02:00, Michael Williams wrote:
>> If you can merge your data, so that you have it like:
>>
>> X | Y | Series
>> 50 | 0 | A
>> 50 | 100 | A
>> 0 | 0 | B
>> 100 | 80 | B
>> 0 | 0 | C
>> etc...
>>
>> You could use X for the X axis, Y for the Y axis, and Series for the
>> optional grouping, you should get what you're wanting. Just make sure
>> you deselect the "is category axis" check box, in the x-axis section of
>> the format chart tab. Let me know if you run into issues.
>
  • Attachment: preview.png
    (Size: 16.90KB, Downloaded 94 times)
Re: Recreate excel xy graph [message #958397 is a reply to message #953708] Fri, 26 October 2012 00:48 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1684
Registered: July 2009
Senior Member

Try this one. I sorted the values based on the x-axis field and also chose to connect missing values.



Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Recreate excel xy graph [message #958835 is a reply to message #958397] Fri, 26 October 2012 08:49 Go to previous messageGo to next message
Nigel Daniels is currently offline Nigel DanielsFriend
Messages: 66
Registered: July 2009
Member
Thanks Michael!

That's got it working, I apreciate your help on this... it had me foxed :)

On 26/10/2012 01:48, Michael Williams wrote:
> Try this one. I sorted the values based on the x-axis field and also chose to connect missing values.
>
>
>
Re: Recreate excel xy graph [message #961073 is a reply to message #958835] Sun, 28 October 2012 02:00 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1684
Registered: July 2009
Senior Member

Not a problem! Smile

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Previous Topic:PPT format report can't be opened with PPT Viewer 2007
Next Topic:a question about y-axis
Goto Forum:
  


Current Time: Fri Dec 19 08:16:20 GMT 2014

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

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