-1

I have a 2 column spreadsheet. The first column is a label, the second is a value. I want to make a chart that displays every single label on the y axis but by default calc displays the labels at intervals, like every 5th one. How can I change this?

tbodt
  • 16,609
  • 6
  • 58
  • 83
user1131308
  • 309
  • 4
  • 12

1 Answers1

1

You can modify the axis when in chart edit mode. To do so:

  1. Double-click on the chart; after this, there's a light grey border around the chart, telling you that you've activeted chart edit mode:

    enter image description here

  2. Open Menu "Format" -> "Axis..." -> "X Axis" (or Y axis, depending o the layout of your chart):

    enter image description here

  3. In the Axis Format window, select the "Label" tab:

    enter image description here

  4. Set the label formatting as desired. The optimal format settings depend on the labels. If they aren't too long, staggering the labels may help. If they don't fit even staggered, then you could modify the text direction, e.g. settiing it to 45 degrees.

tohuwawohu
  • 13,268
  • 4
  • 42
  • 61