How do I include a date column in the Axis in Excel?

G

Greeneliza

I'm creating a graph from a series of values in one column. In the adjacent
column I have the date the value is entered. How can I get these dates to
appear on the axis of the graph?
 
T

trip_to_tokyo

I'm creating a graph from a series of values in one column.  In the adjacent
column I have the date the value is entered.  How can I get these datesto
appear on the axis of the graph?

Please go to:-

http://www.pierrefondes.com/

Item number 52.

Pull up the Workbook on the screen in front of you / The_Solution
Worksheet / highlight the range F 10 to G 21 inclusive / Insert /
Charts group / click on arrow in lower right hand corner / Insert
Chart should launch and it should default to Clustered Column / hit
OK.

You should now get a chart launching on the screen in front of you
with dates along the X (horizontal axis).

This is one way in which it might be done.

If you want to see actual dates in the above example do the
following:-

- highlight cells F 11 to F 21 inclusive

- right click and select Format Cells . . .

- Format Cells should launch

- Number tab / change to Date *14/03/2001 (this is formatted the
European way) / OK

- you should now get dates in full along the X axis.

If my comments have helped please hit Yes.

Thanks.
 

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

Top