1

I made a combo chart where the x-axis is the date field. I have gaps in the date, but want my chart to reflect the gap. For example, I have big gaps in April, May, June, August, September, and October.

11/20/2020
7/21/2020
7/19/2020
4/30/2020
3/28/2020
3/28/2020

How do I show the x-axis with missing date ranges without altering the data? The data is being imported from a CSV elsewhere which I can not change, only read in.

Edit add:

I am using combo chart

My horizontal axis options look like this:

horizontal axis

2

Unfortunately the Combo Chart doesn't support the Treat labels as text for the horizontal axis. The alternative is to use a different chart type like:

  • Area chart
  • Column chart
  • Line chart

and maybe others


First change the chart type to one that supports the required setting, then uncheck the Treat labels as text checkbox

One way to do this

  1. Open the chart editor
  2. One the Setup tab, change the Chart type to one of the chart types mentioned above
  3. Click the Customize tab
  4. Click the Horizontal axis title to expand it
  5. Uncheck the Treat labels as text checkbox

Related

| improve this answer | |
  • I don't see that option in horizontal access. Does it depend on the data type of the column? Or that I have a combo chart? – Sun Mar 4 at 23:44
  • @sun Apparently you don't see this setting because you are using a Combo chart. – Rubén Mar 5 at 0:07

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.