I want to insert the month names in the horizontal axis of a line chart. This should be easy to do, but after for one hour I can't figure out how to do it. This is the sheet that contains the chart and data: Link here

How can I add the month names to the x-axis???

enter image description here


You need to add column A to the chart as labels for the horizontal axis.

  1. Right-click near the bottom of the chart and select Advanced edit...

select Advanced edit...

  1. Select the Chart types tab.
  2. Replace Folha1!C1:C13 with Folha1!A1:A13,Folha1!C1:C13. Select Use Column A as labels.

Change this:

select chart range

To this:

change chart range

  1. Click Update.

Here's the chart with month names in the horizontal axis.

chart with labels

  • Great, now I can see the labels but January is missing. – Nuno Nogueira Jul 26 '16 at 13:40
  • @NunoNogueira The date for January is 2016/01/16. Change that to 2016/01/01 and the axis will show January. Alternatively, at Step 3, select Aggregate column A for slightly different axis labels. – creidhne Jul 26 '16 at 14:08
  • @NunoNogueira If the precise dates on the chart are important, change the chart to a Scatter chart. – creidhne Jul 26 '16 at 14:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.