Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

[Solved]: Excel Graph Is Not Showing All Dates (with Easy Steps)

When you make a graph from worksheet data containing dates, the dates are projected along the horizontal axis of the graph. Excel switches the horizontal axis to a date axis naturally. A date axis can be manually switched from a  horizontal axis. Even if the dates on the worksheet are not in the correct sequence or have different reference units, a date axis exhibits dates chronologically at fixed intervals or based units, such as the number of days, months, or years. This article will demonstrate a step-by-step solution if the Excel graph is not showing all dates.


Download Practice Workbook

You may download the following Excel workbook for better understanding and practice it by yourself.


Step-by-Step Solution If Excel Graph Is Not Showing All Dates

Excel chooses the almost negligible difference between any two time periods in the worksheet data as the basis for the units for the date axis. You can change the unit in Excel from days to months or years if you want to look at how the product performs over a longer time period, like in the case of data for product prices, where the least difference between dates is one day. So, to know the step-by-step solution if the Excel graph is not showing all dates, you can follow the given steps accordingly.


Step 1. Making Data Set with Proper Parameters

In this step, we will create our data set, including some products’ price and their purchase date.

Making Data Set with Proper Parameters to Create Excel Graph


Step 2. Utilizing Charts Group

Excel’s charts group provides a range of chart types. In particular, many charting tools enable users to visualize complex data in straightforward, graphical forms.

  • Firstly, select the Product Price and Purchase Date column.

Utilizing Charts Group if Excel Not Showing All Dates

  • Firstly, go to the Insert tab after selecting the data range from the given data set.
  • Secondly, choose the Insert Column or Bar Chart from the Charts
  • Thirdly, select the Clustered Column option from the 2-D Column.

Read More: Selecting Data in Different Columns for an Excel Chart


Step 3. Creating Excel Graph

When comparing precise data groups like frequency, quantity, range, or measurements, bar charts can be helpful. They are also employed to show patterns.

  • As a result, you will see the output graph in the below image.
  • So, you will see in the data set that some of the dates are missing and the Excel creates some blank space for the missing dates.

Creating Excel Graph

Read More: How to Group Data in Excel Chart (2 Suitable Methods)


Step 4. Utilizing Format Axis Command

Excel offers date-display options that can close this blank space by utilizing the Format Axis command.

  • Firstly, right-click on the X-axis.
  • Then, choose the Format Axis command.

Utilizing Format Axis Command if Excel Graph Not Showing All Dates

  • After that, the Format Axis window will open.
  • Besides, select the Text Axis option from the Axis options.


Step 5. Showing Final Output

  • Finally, you will see the final output in the below image. The results will be comprised of all the dates including.

Showing Final Output if Excel Graph Not Showing All Dates

Read More: How to Show Only Dates with Data in Excel Chart


Conclusion

In this article, we’ve covered step-by-step solutions If the Excel graph is not showing all the dates. We sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on Excel, you may visit our website, ExcelDemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.


Related Articles

Bishawajit Chakraborty

Bishawajit Chakraborty

I'm Bishawajit Chakraborty. Hello. I graduated from Rajshahi University of Engineering & Technology (RUET) with a degree in Mechanical Engineering. I'm working with ExcelDemy as a Content Developer for Excel & VBA. You can visit our website, Exceldemy if you'd like to read my published articles on MS Excel and VBA.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo