Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Chart (Excel 2000)

    Hi Gurus,

    How can I plot a bar chart which has two different series of vastly different values. I have attached the data file.

    Thanks in advance.
    Novice excelite
    Attached Files Attached Files

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

    Re: Chart (Excel 2000)

    This can be done by reorganizing the data slightly and by plotting the thrid and fourth series on the secundary axis, so that they can use a different scale.
    Attached Files Attached Files

  3. #3
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart (Excel 2000)

    Thanks Hans,

    That was marvelous. Can you tell me how to go about charting it so that I can make some more charts.
    Rgds
    Novice

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

    Re: Chart (Excel 2000)

    Here are some websites that provide a lot of examples of charting techniques:

    AJP Excel Information - Charts
    Peltier Technical Services, Inc.

    and a web page listing more links:

    Contextures -- Excel Chart Links

  5. #5
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart (Excel 2000)

    Hi Hans,

    Thanks for the info. As I am in a bit of hurry can you pinpoint which method you used to help me out.

    Rgds
    Novice

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

    Re: Chart (Excel 2000)

    I was away from my PC, so I hope this isn't too late. See Creating a Clustered-Stacked Column Chart.

  7. #7
    Lounger
    Join Date
    May 2004
    Location
    Chicago, Illinois, USA
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart (Excel 2000)

    P.S. The link has changed to a new location : . Thanks so much, Hans, I knew you would know the answer to this! Thank goodness for Woody's Lounge searches. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

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

    Re: Chart (Excel 2000)

    You're welcome. But I'm confused - your link points to the same URL as mine.

  9. #9
    Lounger
    Join Date
    May 2004
    Location
    Chicago, Illinois, USA
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart (Excel 2000)

    Sure does... But when I was clicking your link before, it was taking me to the dreaded Page Cannot Be Found. Now it's working fine though. Go figure, perhaps there are strange cosmic rays about!

    In any case, THANK YOU for pointing me to the right answer without even being asked.

Posting Permissions

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