I want to create a bar chart in Google Sheets which looks (pretty much) like this :

bar chart

From data that looks like this :


As you can see in the first picture the date labels along the X axis skip a date so that every second pair of values is left with a label. I want every pair of red/blue values to share a value from the '1' row shown in the sheet.

EDIT1: The Data range is : C1:J1,B5:AA5,B25:J25 .

The following screen dump gives you a fuller view of all the settings

enter image description here

  • @pnuts : thank you for your comment. I'm just about to edit the question to include the information about the Data range.
    – glaucon
    Commented Nov 5, 2017 at 3:08

1 Answer 1


Google Sheets will do this when the axis units are recognized as a date. Double click on the horizontal axis, and check the Treat Labels As Text setting.

Before: enter image description here

After: enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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