Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    chart help (2000)

    Hi my boss just handed me a paper with a picture of a chart and said make a excel database that based on that chart. I know nothing about making charts. I have attached example of how the picture looked. Please help I have no clue how that got the numbers to make that chart.
    thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: chart help (2000)

    With the numbers in your table, it is impossible to get the numbers on the secondary axis. Do you know if the numbers along the value axes are the actual numbers, or do they represent thousands? If they are the actual numbers, the inpatient admissions series would become a stair step line. See attached.

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: chart help (2000)

    If you make the year a four digit integer, then you can make the chart a smoothed XY scatter. See attached. HTH --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  4. #4
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: chart help (2000)

    Have you played with the chart wizard? Just click the chart icon on the toolbar or use menu Insert/Chart. Also your years should probably be four digit to make it more clear. See attached (one with two axis, one with a secondary y-axis).

    Deb

Posting Permissions

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