+ Post New Thread
Results 1 to 4 of 4
General Chat Thread, Help with Excel Chart in General; Got that Monday feeling and can't seem to get my head around this one. I have two columns of data, ...
  1. #1
    TechSupp's Avatar
    Join Date
    Mar 2007
    Location
    South Yorkshire
    Posts
    1,917
    Thank Post
    315
    Thanked 122 Times in 103 Posts
    Rep Power
    42

    Help with Excel Chart

    Got that Monday feeling and can't seem to get my head around this one. I have two columns of data,
    Age at Death Total
    23 2
    1 3
    34 4
    45 5
    56 7
    3 3
    23 4
    11 5
    32 2
    2 4

    giving ages people died at and how many of them died at that age. I want a histogram with the ages along the X and the total dies on the Y but can I get it! Don the usual highlighting both and selecting graph but don't seem to get a graph that I can select and age and cross reference it to the Y to see how many died at that age.

  2. #2

    elsiegee40's Avatar
    Join Date
    Jan 2007
    Location
    Kent
    Posts
    9,848
    Thank Post
    1,829
    Thanked 2,257 Times in 1,662 Posts
    Rep Power
    806
    In Excel

    1. Remove the header for age at death

    2. Select all the data including the header row

    3. Click on the chart wizard icon

    4. Choose your chart

    5. Click on next and label you axes, etc

    6. Click on next and decide whether you want it as a separate tab or as an object on the worksheet.
    Attached Files Attached Files
    Last edited by elsiegee40; 9th November 2009 at 11:40 AM.

  3. Thanks to elsiegee40 from:

    TechSupp (9th November 2009)

  4. #3
    TechSupp's Avatar
    Join Date
    Mar 2007
    Location
    South Yorkshire
    Posts
    1,917
    Thank Post
    315
    Thanked 122 Times in 103 Posts
    Rep Power
    42
    Don't know what I was doing wrong! Thanks for that

  5. #4

    elsiegee40's Avatar
    Join Date
    Jan 2007
    Location
    Kent
    Posts
    9,848
    Thank Post
    1,829
    Thanked 2,257 Times in 1,662 Posts
    Rep Power
    806
    Quote Originally Posted by TechSupp View Post
    Don't know what I was doing wrong! Thanks for that

    It doesn't work if you have a column header for Age at Death as it assumes the numerical ages are to be used as data for the graph.

    The simplest way to get round this is to remove the age column header and then use the chart wizard

SHARE:
+ Post New Thread

Similar Threads

  1. [Pics] Computer Hardware Chart
    By DaveP in forum Jokes/Interweb Things
    Replies: 17
    Last Post: 15th March 2011, 05:37 PM
  2. gantt chart in excel
    By econtent in forum Windows
    Replies: 3
    Last Post: 21st April 2009, 04:30 PM
  3. Excel 2003 problem with chart...
    By kennysarmy in forum Windows
    Replies: 6
    Last Post: 12th December 2008, 07:04 PM
  4. Chart-it Alternative
    By vunsev in forum Educational Software
    Replies: 0
    Last Post: 4th June 2008, 09:17 AM
  5. Excel 2007 Chart Types
    By wesleyw in forum How do you do....it?
    Replies: 0
    Last Post: 12th September 2007, 11:01 AM

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
  •