Ask Your Question

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

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.


edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by Alex Kemp
close date 2020-10-13 22:26:37.384961

3 Answers

Sort by » oldest newest most voted

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

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

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

Question Tools



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

Seen: 31,586 times

Last updated: Jul 11 '20