Start Date on X Axis

G

Guest

I have a simple bar chart where I want the date in the form of mo/dy to start
at 9/12 and go to 9/17 on the X axis.
I have the form and increment correct but I can't get the start date correct
I am trying to use the scale tab on format axis.
What does Value (Y) axis crosses at mean also, between dates, maximum value
and entered value?
Thanks
 
J

Jon Peltier

If your X data are in dates, make sure you have a date scale axis. Go to
Chart menu > Chart Options > Axes tab, and make sure the Time Scale option
is selected under Category Axis. Then you should be able to double click on
the X axis and set the axis parameters you want.

The best way to learn the other options is to toggle each on and off to see
how the chart appearance changes.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
774-275-0064
208-485-0691 fax
(e-mail address removed)
http://PeltierTech.com/
_______
 
G

Guest

Thanks for the reply Jon,
I did as you instructed but I was not successful. My dates are
1/1, 1/2, 1/3, 1/4, 1/5, 1/6
I want
9/12, 9,13, 9/14, 9/15, 9/16, 9/17

Here are the valuse I used in format axis scale tab

Min checked 9/12, Max checked 9/17, Base unit checked default day(s),
Major unit checked 1, days - default, Minor unit not checked,
Value Y axis crosses at checked 9/12
remaining three boxes not checked
Clicked OK
 
J

Jon Peltier

Does your series use the desired dates (9/12, 9/13, 9/14, 9/15, 9/16, 9/17)
as its X values? Go to Chart menu > Source Data > Series tab, click on the
series, and see which range is found in the Category (X) Axis Labels box.

Are these truly numerical dates, and not somehow interpreted by Excel as
text only labels? Make the column twice as wide as the contents, format the
cells to have General horizontal alignment. Are they left aligned like text,
or right aligned like numbers?

- Jon
 
G

Guest

Thank you Jon, that worked.
I hadn't noticed the Caterory (X) axis labels box.
I was trying to get the desired results with Format Axis - Scale tab.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Y-axis values correspond to x- axis value 1
Formatting 'X' Axis -- 2 fundamental differences 7
Horizontal axis to the bottom 1
Date Range for X-Axis Labels 2
Chart distorts secondary axis when the x-axis is logarithmic 5
Can't get the x-axis to cross at value 0 for both y-axes 3
Line Chart - Problems with labeling X-Axis 3
Crossing Axis Values 2

Top