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 09:19 Go to next message
Nigel Daniels is currently offline Nigel Daniels
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] Mon, 22 October 2012 21:00 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1424
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
Actuate – The BIRT Company™

BIRT Developer Center
Check out the new, free BIRT Viewer Toolkit
Re: Recreate excel xy graph [message #957644 is a reply to message #954377] Thu, 25 October 2012 07:33 Go to previous messageGo to next message
Nigel Daniels is currently offline Nigel Daniels
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 10:51 Go to previous messageGo to next message
Nigel Daniels is currently offline Nigel Daniels
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 74 times)
Re: Recreate excel xy graph [message #958397 is a reply to message #953708] Thu, 25 October 2012 20:48 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1424
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
Actuate – The BIRT Company™

BIRT Developer Center
Check out the new, free BIRT Viewer Toolkit
Re: Recreate excel xy graph [message #958835 is a reply to message #958397] Fri, 26 October 2012 04:49 Go to previous messageGo to next message
Nigel Daniels is currently offline Nigel Daniels
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] Sat, 27 October 2012 22:00 Go to previous message
Michael Williams is currently offline Michael Williams
Messages: 1424
Registered: July 2009
Senior Member

Not a problem! Smile

Michael
Actuate – The BIRT Company™

BIRT Developer Center
Check out the new, free BIRT Viewer Toolkit
Previous Topic:PPT format report can't be opened with PPT Viewer 2007
Next Topic:a question about y-axis
Goto Forum:
  


Current Time: Wed Apr 16 00:22:46 EDT 2014

Powered by FUDForum. Page generated in 0.21905 seconds