Prev: How do I keep formatting when creating a chart from a pivot?
Next: Template for Hours+ Commission
From: Greeneliza on 16 May 2010 10:54
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?
From: trip_to_tokyo on 16 May 2010 13:19
On May 16, 4:54 pm, Greeneliza <Greenel...(a)discussions.microsoft.com>
wrote:
> 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?

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.



 | 
Pages: 1
Prev: How do I keep formatting when creating a chart from a pivot?
Next: Template for Hours+ Commission