Home » Archived » BIRT » Recreate excel xy graph
|
| Re: Recreate excel xy graph [message #954377 is a reply to message #953708] |
Tue, 23 October 2012 01:00   |
|
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
Developer Evangelist, Silanis
|
|
|
| Re: Recreate excel xy graph [message #957644 is a reply to message #954377] |
Thu, 25 October 2012 11:33 |
 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 14:51 |
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 296 times)
|
|
| | | |
Goto Forum:
Current Time: Thu Dec 26 16:51:01 GMT 2024
Powered by FUDForum. Page generated in 0.03490 seconds |
] 
Search
Help
Register
Login
Home
