Graphic with multiple curves

classic Classic list List threaded Threaded
3 messages Options
Marco A.G.Pinto Marco A.G.Pinto
Reply | Threaded
Open this post in threaded view
|

Graphic with multiple curves

Hello!

Imagine I want to draw 12 curves (months) all in the same graphic, one
for each month with different x and y:
month,x,y
Jan,10,20
Jan,15,30
Jan,20,20
Feb,5,10
Feb,10,15
Feb,30,30
etc.

How can I do it in Calc?

Thank you!

Kind regards,
         >Marco A.G.Pinto
           ----------------------


--

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Robert Großkopf Robert Großkopf
Reply | Threaded
Open this post in threaded view
|

Re: Graphic with multiple curves

Hi Marco,

>
> Imagine I want to draw 12 curves (months) all in the same graphic, one
> for each month with different x and y:
> month,x,y
> Jan,10,20
> Jan,15,30
> Jan,20,20
> Feb,5,10
> Feb,10,15
> Feb,30,30
> etc.
>
> How can I do it in Calc?

I have tried this, but I 'm not a Calc-expert:
Marked the data
Opened the wizard for charts
Choosed xy as chart-type.
... and now edited all data-series:
(Name for the first serie to a field with Jan, Feb etc ...)
It's very much editing here.

So I tried another version:
First I created a new form fo the data:
        Jan Feb
0
5 10
10 20 15
15 30
20 20
25
30 30
...
Then I started the wizard, choosed xy as chart-type and got the right
result without editing data-series any more.

Regards

Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Pedro Pedro
Reply | Threaded
Open this post in threaded view
|

Re: Graphic with multiple curves

In reply to this post by Marco A.G.Pinto
Hi Marco

You need to rearrange the data to get what you want. You need a column for
each month (the month name will be used as the label for the line)

x,Jan,Fev
10,20,
15,30,
20,20,
5,,10
10,,15
30,,30

Then simply select all data and choose a XY plot with lines

Cumprimentos,
Pedro



--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted