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

I’m using LibreOffice 4.3.4.1 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?

Verify if data are values not values as text.

I just figured out the problem! :slight_smile:

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.

Eric

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

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

See the first image…

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.

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.