Home » Archived » BIRT » Recreate excel xy graph
Recreate excel xy graph [message #953708] |
Mon, 22 October 2012 09:19  |
Eclipse User |
|
|
|
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 #957644 is a reply to message #954377] |
Thu, 25 October 2012 07:33   |
Eclipse User |
|
|
|
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   |
Eclipse User |
|
|
|
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 319 times)
|
|
| | | |
Goto Forum:
Current Time: Fri Apr 25 13:07:09 EDT 2025
Powered by FUDForum. Page generated in 0.10033 seconds
|