Ask Your Question

Mysterious number "10" appears in centre of calc chart

asked 2017-09-08 09:48:13 +0200

cowshill gravatar image

updated 2020-07-07 15:20:55 +0200

erAck gravatar image

I have a calc line chart which, for reasons totally mysterious to me, displays the number 10 in the centre of the chart. This number is part of the chart, as it moves with the chart when I move the chart in the spreadsheet. However, when I double click the chart to edit its properties, the number disappears, only to reappear when I exit the chart edit mode. There is no cell in the spreadsheet with the number 10, and I can think of no reason why any number should be displayed in the centre of the chart display. Can anyone suggest why this number appears in the chart and how to remove it?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2020-07-06 11:46:33 +0200

erAck gravatar image

This can happen if you select the chart with a single click and start typing as the frame object is just a drawing object that also can be "texted" like any other drawing object. To remove the text just single click the chart to select it again and hit F2 to edit the text, then Ctrl+A and Delete. Or context menu to format or position the text..

edit flag offensive delete link more



answered 2020-07-05 17:40:07 +0200

Gazbo gravatar image

updated 2020-07-05 18:25:58 +0200

ajlittoz gravatar image

I just found the same issue. I have been saving seperate (Same format and chart design) weekly spreadsheets, for my blood pressure and BPM readings, to spot any trends etc. I simply save the week one as "Week 2 then week 3 etc, (to end up with one separate, but same format spreadsheet & chart for each week) then re-populate it accordingly with that week's data, and the chart on that spreadsheet loads up to suit, and so on. My Week 3 sheet though, suddenly developed this issue, although a different number appeared - centre of chart.(Mine was 131110 - which doesn't seem to relate to anything)

I simply highlighted and copied all my data from the week 3 spreadsheet, then closed it. I then opened sheet 2. I then deleted the existing data from sheet 2, and pasted in the sheet 3 data. (The graph immediately adjusted to the new data.I then (Still on the updated sheet 2) hit "save as" , and simply changed the existing title from Sheet 2, to sheet 3. It then does the usual "Sheet 3 already exists" routine. I simply chose yes to over write it. that way, sheet 2 was still intact, but a replacement sheet 3 has been created, using only the sheet 3's original data. Problem gone. Hope that helps. If you only have one data sheet, then I don't know, other than starting afresh, either redoing the chart from scratch, or starting over completely.

(edited by ajlittoz to insert a paragraph break where poster intended)

edit flag offensive delete link more


This is no solution to the problem. Move you "me too" complaint into a comment under the initial question and delete this "non-answer".

Also, WRITING IN UPPERCASE is considered shouting according to netiquette. Please, behave, and write "as usual".

ajlittoz gravatar imageajlittoz ( 2020-07-05 18:01:20 +0200 )edit

sorry. caps lock. wasn't looking until too late. (I have arthritis and didn't realise I'd caught it.)

Gazbo gravatar imageGazbo ( 2020-07-05 18:13:02 +0200 )edit

If you still have a spreadsheet with the issue (on anonymous non intrusive data), attach it to your answer for analysis.

ajlittoz gravatar imageajlittoz ( 2020-07-05 18:26:53 +0200 )edit

i rectified the issue, as above. thankyou.

Gazbo gravatar imageGazbo ( 2020-07-05 18:52:18 +0200 )edit

Yes, I saw you found a workaround but it might be interesting for others to diagnose the original cause.

If it happens again, attach a file to your answer. It will automatically refresh the question and push it at top of "active" ones.

ajlittoz gravatar imageajlittoz ( 2020-07-05 19:29:12 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-09-08 09:48:13 +0200

Seen: 127 times

Last updated: Jul 06 '20