Excel 2003 problem with chart...

[kennysarmy]

I am trying to present to my Senior Management Team the profile of our pc ages.

I have the following data.
Supply Date No.
20-Jul-04 45
01-Nov-04 2
17-Nov-04 1
10-Jan-05 1
23-Mar-05 20
04-May-05 2
22-Jul-05 43
13-Oct-05 1
12-Dec-05 1
31-Mar-06 62
25-Jul-06 43
18-Sep-06 20
17-Nov-06 1
18-Dec-06 24
15-Jan-07 2
22-Jan-07 2
26-Feb-07 8
26-Apr-07 2
16-May-07 2
31-Jul-07 152
28-Nov-07 1
07-Apr-08 106
21-Jul-08 10
23-Jul-08 17
01-Oct-08 2
19-Dec-08 80


I cannot for the life of me work out how to do a chart with an X-axis time line that shows bars for each no. of pc's bought at each point along the timeline...

any ideas?

[RabbieBurns]

www.peninsulafm.com/test22.xls

edit:

column each for the 2 series of data, highlight it all, click the chart, and just follow the wizard

[kennysarmy]

I know how to make a chart LOL

what I cannot get is the timespacings correct on the X-axis coupled with a bar chart type display

[rush_tech]

Any chance you could post the .xls file

[RabbieBurns]

i dont know what you mean then. sorry.

[kennysarmy]

I've sorted it now...but what I had trouble with is that excel when creating a chart will take the first column of data and equally space that along the X-axis, in my case the x-axis data was dates and the time spacing between each row of data was not consistent so equal spacing gave the wrong impression on the graph. The x-axis can be altered to be a time-value but I was getting very thin bars....

[User3204]

The technical term is "Histogram" not "Bar chart".. I did Statistics a long time ago... it was very boring.
What you probably needed to do to get XL to do it properly was create a start/end date for each number. So for the first date instead of 20/jul do 19/jul to 21/jul.