• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 167
  • Last Modified:

How to show axis on Excel chart with actual dates rather than sequential dates

How can I get a chart to show all dates so that the dates on which nothing happens show up with no data?
0
agwalsh
Asked:
agwalsh
1 Solution
 
Rgonzo1971Commented:
Hi,

Select the Axis, right-click
Format Axis
Axis Options
Axis Type
Date Axis
Ok

Regards
0
 
agwalshAuthor Commented:
Does the job :-)
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now