Ask Your Question

CALC: why is there no line (or points) in my XY Scatter graph? [closed]

asked 2014-12-06 21:10:05 +0200

neutron68 gravatar image

updated 2016-03-06 22:17:45 +0200

Alex Kemp gravatar image

I'm using LibreOffice in Windows 7 64-bit. I'm trying to create a simple line graph (using XY Scatter graph) of an account's balance vs. the date.

I have 2 columns of data: A is date, B is account balance.

I have the cells in the date column set as type date.
I have the cells in the balance column set as currency.

When I click on the Graph Wizard, I tell it to create an XY Scatter graph. I select the range of data, and I get a graph with no data points and no line.

Any idea what the problem is?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-06 22:18:12.996409



Verify if data are values not values as text.

m.a.riosv gravatar imagem.a.riosv ( 2014-12-06 22:47:10 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2014-12-07 00:22:29 +0200

neutron68 gravatar image

I just figured out the problem! :)

The problem was occurring during the CSV file import process.

The numbers in the Balance column were starting with the characters '$

So, they appeared like this in the data boxes '$123,000.82

After I removed the '$ characters from the Balance data, the XY Scatter graph worked as desired!

Thanks for giving suggestions.


edit flag offensive delete link more


On the CSV import box you can configure the column type for those that are not properly imported.

m.a.riosv gravatar imagem.a.riosv ( 2014-12-07 00:40:31 +0200 )edit

answered 2014-12-06 22:51:17 +0200

Rugslug gravatar image

updated 2014-12-06 23:36:05 +0200

Did you choose what type of Scatter Graph? That is Points / Points & Lines / Lines Only / 3-D Lines?

See the first image...

image description

If you did, you may need to right click on a data point, format data series, and select the type and colour of line.

See the second image....

image description

Added (missed the 'no data points'): Or (other than what Mariosv Said), if you edit the chart, a toolbar is displayed under the menu toolbar. It should indicate "Chart", select the data series, then Format Selection and edit line type. This scenario happened to me recently.

edit flag offensive delete link more


Note that the data pair (date label, $ value) in this case is a linear series, best displayed on a Line chart. An XY (Scatter) chart uses value pairs that are both variable.

oweng gravatar imageoweng ( 2016-03-27 14:08:37 +0200 )edit

Question Tools

1 follower


Asked: 2014-12-06 21:10:05 +0200

Seen: 3,072 times

Last updated: Dec 07 '14