+ Post New Thread
Results 1 to 7 of 7
Windows Thread, Excel 2003 problem with chart... in Technical; I am trying to present to my Senior Management Team the profile of our pc ages. I have the following ...
  1. #1
    kennysarmy's Avatar
    Join Date
    Oct 2005
    Location
    UK
    Posts
    1,254
    Thank Post
    75
    Thanked 45 Times in 31 Posts
    Rep Power
    30

    Excel 2003 problem with chart...

    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?

  2. #2

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,476
    Thank Post
    1,305
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    198
    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
    Last edited by RabbieBurns; 9th December 2008 at 04:13 PM.

  3. #3
    kennysarmy's Avatar
    Join Date
    Oct 2005
    Location
    UK
    Posts
    1,254
    Thank Post
    75
    Thanked 45 Times in 31 Posts
    Rep Power
    30
    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

  4. #4

    rush_tech's Avatar
    Join Date
    Jul 2006
    Location
    Nottingham
    Posts
    1,386
    Thank Post
    109
    Thanked 261 Times in 197 Posts
    Rep Power
    192
    Any chance you could post the .xls file

  5. #5

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,476
    Thank Post
    1,305
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    198
    i dont know what you mean then. sorry.

  6. #6
    kennysarmy's Avatar
    Join Date
    Oct 2005
    Location
    UK
    Posts
    1,254
    Thank Post
    75
    Thanked 45 Times in 31 Posts
    Rep Power
    30
    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....

  7. #7
    User3204's Avatar
    Join Date
    Aug 2006
    Location
    Wirral
    Posts
    769
    Thank Post
    55
    Thanked 66 Times in 62 Posts
    Rep Power
    33
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. Unable to print from Word or Excel 2003
    By pennywest in forum Windows
    Replies: 8
    Last Post: 30th November 2009, 06:41 AM
  2. [MS Office - 2003] Excel 2003
    By jcs808 in forum Office Software
    Replies: 0
    Last Post: 24th September 2008, 10:59 AM
  3. Excel Problem
    By TechSupp in forum General Chat
    Replies: 0
    Last Post: 2nd November 2007, 10:08 PM
  4. Excel 2007 Chart Types
    By wesleyw in forum How do you do....it?
    Replies: 0
    Last Post: 12th September 2007, 11:01 AM
  5. Help!!!!!!! With Excel 2003
    By jodielynn in forum Windows
    Replies: 3
    Last Post: 16th May 2007, 04:19 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •