Chart Dates

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

userman

Thread Starter
Joined
Jul 2, 2012
Messages
45
I have created a chart with selected sequential dates. Some of the dates are missing i:e 12/6 - 12/9 and some other as well. Well, the chart created displays not the dates selected, but rather every other day. Can someone offer a solution/reason for this? I'm setting this up for a presentation and it is really getting rather frustrating.:confused:
 

etaf

Wayne
Moderator
Joined
Oct 2, 2003
Messages
65,454
is this the X-axis as it will try an squeeze into the area

i have often used a format making the text into an angle and then all the dates can be seen - But the chart area needs to be large enough , as that may not work

can you post an example spreadsheet - so we can see the issue
 

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,612
Take a look at the axis settings, it shows the interval to display, if it's set to 5 every 5th date is shown, etc.
 

userman

Thread Starter
Joined
Jul 2, 2012
Messages
45
It was the size of the chart area. Once I widened the chart, the dates fell into place as they should.

Thanks for the solutions.
 

userman

Thread Starter
Joined
Jul 2, 2012
Messages
45
I'm back with another issue with the charts. Now they display days that are not even included in the chart range - i.e. days closed. The chart is numbering every day sequentially within the range including the days closed. For example, we were closed on 24 and 25 DEC 12, but the chart is displaying these dates in the axis. Any help please?
 

Attachments

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top