google sheetsgoogle-sheets-charts
I want to create a bar chart in Google Sheets which looks (pretty much) like this :
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
My understanding of your requirement is as below, though this does not apply your sample data:
The layout of the left four columns is required - in effect I have substituted:
10 100
30 110
60 150
80 180
for your sample data in the OP.
I selected the data area, Charts, Charts, Line and checked both Use row 1 as headers and Use column A as labels. This ended up with the appearance of a scatter plot but in Advanced edit..., Customise, Features this, oddly, was fixed by checking Plot null values.
The colours, datapoints etc were customised for the image.
Instead of using a Line chart use the Time Line Chart, named as Annotated time line in Chart types - Google Docs editors Help. The look and feel of this chart was not updated yet, but it still works and do a great job handling date-time labels for the horizontal axis.
Best Answer
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 Textsetting.Before:
After: