Calc chart's axes disappeared; how to get them back?

I opened a Calc document which contains a simple two-column series of daily data-- date and number. There’s a chart of that data to the right. Today I opened the document and added a row of new data, and saw the point appear on the right of the chart. Then I noticed the chart had lost its axes, i.e., the textual y-axis labels in the left margin and x-axis labels in the bottom margin.

I’m a new LO user; this .ods started life as an .xlsx but the .ods chart had axes until today. I couldn’t find anything that seemed relevant in the menus or toolbars. The help for Axes - showing begins with

Specifies the axes to be displayed in the chart.
To access this command…
Choose Insert - Axes (Charts)

but the Insert menu contains no Axes command. Its “Chart…” command seems to be only for starting over with a new chart. Is that what I must do?

Just guessing:

  • Edit your chart (double click, or secondary click and Edit).
  • Hover your mouse/touchpad pointer over the chart, and when do you see Chart, drag it to the right and up. Maybe you must resize the Chart by its handlers.

And what occur if do you delete the last added row of data?

Edit, drag right and up left more blank space to the left and bottom, but no axes.

Deleting the last row did nothing except remove its point on the chart.

…But Save As an Excel .xlsx brought the axes back when opened in Excel. When the .xlxs is opened in LO, no axes. But after Save As .ods in Excel, then the axes remain after opening the new .ods in LO.

If you are not in Edit mode for the chart then you will see the Calc Insert menu which can only insert a new chart.
If you are in Edit mode for the chart then you will see the Chart Insert menu which allows you to add or delete items in the chart your are editing.

See @LeroyG first point.

3 Likes

OK, got it.

It’s an X-Y Scatter type. Is there any way to change the color of the little black squares representing the value points?

1 Like

Right click the line and select Format Data Series

  • If you change the colour of the line then the markers will change colour to match the line colour.
  • If under Icons you select Gallery then you can choose from the coloured bullets in the Gallery so the markers will be a different colour to the line…
2 Likes

Perfect! Thanks so much for your thorough help!