Actual dates on graph axis

rvaiden

New Member
Joined
Mar 12, 2002
Messages
5
When I try to get actual dates as axis labels, I keep getting the "week of" date rather than the actual day. How do I set the axis to actuals, rather than assuming the week?
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
On 2002-09-25 06:40, rvaiden wrote:
When I try to get actual dates as axis labels, I keep getting the "week of" date rather than the actual day. How do I set the axis to actuals, rather than assuming the week?

Hi - not enough info to suggest a diagnosis. Care to post back with a little more detail about the dource data for your axis, how it's formatted, exactly what you're getting on your graph at the moment etc

Paddy
 

rvaiden

New Member
Joined
Mar 12, 2002
Messages
5
On 2002-09-25 18:20, PaddyD wrote:
On 2002-09-25 06:40, rvaiden wrote:
When I try to get actual dates as axis labels, I keep getting the "week of" date rather than the actual day. How do I set the axis to actuals, rather than assuming the week?

Hi - not enough info to suggest a diagnosis. Care to post back with a little more detail about the dource data for your axis, how it's formatted, exactly what you're getting on your graph at the moment etc

Paddy

I am trying to do a scatter graph of pieces shipped by particular day. When I enter the actual dates of shipments as the x-axis, excel automatically scales the axis beginning with the week of the shipment, not the actual date that I would like on the axis label. I have gotten around the problem in the short term by converting the date format to a general format and finding the numeric code for the day I want, then entering that as the beginning of the axis scale. This solution seems cumbersome, and still does not really give me the axis labels I desire.

rvaiden
 

ThePencilQueen

Board Regular
Joined
Jun 26, 2002
Messages
109
Excel only groups the dates because it can't fit them all onto the x axis. Try making the graph as big as your screen will allow, changing the font size of the x axis to 8 or 6 or smaller and changing the alignment of the x axis labels to be vertical.

If you try all this and the graph still doesn't show all the dates then try using separate graphs for a smaller range of dates (ie a month or a fortnight at a time)
 

Tom@CPC

Board Regular
Joined
May 22, 2002
Messages
209

ADVERTISEMENT

Excel will try to guess the major and minor ticks for you (the date values shown)from its own default characteristics and format the graph accordingly. To remedy this, right click on one of the date values. This should allow you to set the axis properties. Depending on how Excel formated in the first place, you may see dates in the fields or the numerical equivalent for the date. Inn any event, change major and minor to 1. This will give you one tick for each date.

HTH, Tom
Regards
 

rvaiden

New Member
Joined
Mar 12, 2002
Messages
5
On 2002-09-26 08:49, Tom@CPC wrote:
Excel will try to guess the major and minor ticks for you (the date values shown)from its own default characteristics and format the graph accordingly. To remedy this, right click on one of the date values. This should allow you to set the axis properties. Depending on how Excel formated in the first place, you may see dates in the fields or the numerical equivalent for the date. Inn any event, change major and minor to 1. This will give you one tick for each date.

HTH, Tom
Regards
 

Watch MrExcel Video

Forum statistics

Threads
1,123,271
Messages
5,600,651
Members
414,399
Latest member
Ninjee

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top