Ask Your Question
0

Blank chart for dates and currency

asked 2017-11-01 04:24:23 +0100

I'm trying to plot my finances, but my chart comes up blank.

Here's a link to it: https://drive.google.com/file/d/0B3wo...

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-11-01 06:02:05 +0100

KH gravatar image

updated 2017-11-01 06:27:19 +0100

The cells in the "balance" column are all quoted, which makes them behave as text even if you try to change the cell format to something else. To see this, select a cell and look at the formula bar. You can also see it if you double click to edit.

There are several ways to fix this. Using Find and Replace to remove the quote seems to be the best general solution. See: https://ask.libreoffice.org/en/questi....

edit flag offensive delete link more

Comments

Ah, thank you, I fixed this with the dates but didn't think to do it with the currency.

EmergencyTemporalShift gravatar imageEmergencyTemporalShift ( 2017-11-02 05:06:28 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-11-01 04:24:23 +0100

Seen: 12 times

Last updated: Nov 01 '17