Graphic with multiple curves

users
#1

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,

#2

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

#3

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