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]

http://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

Edited December 9, 2008 by RabbieBurns

[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.