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

[neutron68]

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?

[mariosv]

Verify if data are values not values as text.

[neutron68]

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.

Eric

[mariosv]

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

[Rugslug]

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…

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.

[oweng]

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.