Ask Your Question
0

how to create a chart from table of X and Y data

asked 2017-08-28 04:02:44 +0200

JensenHealey gravatar image

updated 2020-07-11 22:37:18 +0200

Alex Kemp gravatar image

I have a data set that looks like:

My input data set

I am attempting to create a chart from this data set. However once I have the data pasted into Calc and then try to insert a chart instead of create a x - y line chart using my two columns of data, it seems to want to create two line graphs with the index as X and each column as the Y data. So like this:

Calc screwing up chart

So there must be something simple I am doing wrong. Can anyone please explain my error?

Thanks in advance.

Sven

edit retag flag offensive close merge delete

4 Answers

Sort by » oldest newest most voted
0

answered 2017-08-28 04:49:04 +0200

librebel gravatar image

Hello @JensenHealey,

try this: go to "Data Series" in the Chart Wizard dialog, and remove Column D from the Data Series. HTH, lib

edit flag offensive delete link more
0

answered 2017-08-28 04:35:59 +0200

JensenHealey gravatar image

Nevermind, I found an EXCELLENT video on YouTube that explained what I wanted to do. That video can be found at:

How to use Calc for best fit straight line

edit flag offensive delete link more
0

answered 2017-08-28 13:51:41 +0200

JBF gravatar image

You must choose the (XY) Scatter chart type.

edit flag offensive delete link more
0

answered 2017-08-28 22:07:44 +0200

You can easily create your chart online with this online tool https://livegap.com/charts

edit flag offensive delete link more

Comments

The question was for LibreOffice Calc...

I'm not sure it's the pure place to do your advertising.

JBF gravatar imageJBF ( 2017-08-29 06:54:16 +0200 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2017-08-28 04:02:44 +0200

Seen: 22,829 times

Last updated: Aug 28 '17