Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    154
    Thanks
    3
    Thanked 1 Time in 1 Post

    Combined point & bar chart (Excel 2000)

    Hi, I'm doing some pay modelling using specialist software, basically I don't trust it and I'm going to do it on Excel instead.

    One of the key functions of the specialist software is the production of graphs like the one that I attach. The key point of this graph is that the "bars" are not of equal width. Is there a way to do this in Excel? Or with an add-in? (you'll have to double click on the attached graph to get a proper view of it)

    Thanks
    jim

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combined point & bar chart (Excel 2000)

    I know it isn't the same, but what about a bubble chart?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    154
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Combined point & bar chart (Excel 2000)

    No, doesn't really do it. How it works is that the people inside the box, their pay stays the same. The people vertically above the box get a pay drop & the ones below the boxes get a raise.

    I need to manipulate the boxes to get the least impact on staff. This is easy to do on the spreadsheet but it's far easier to visualise if you've the chart to look at as well.

    Thanks anyway,
    Jim

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combined point & bar chart (Excel 2000)

    The site on Excel charting (as far as I'm concerned) is:
    http://www.peltiertech.com

    Maybe this one has potential:

    http://www.peltiertech.com/Excel/Cha...dthColumn.html
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    154
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Combined point & bar chart (Excel 2000)

    Thanks, the link helped. There's actually a far simpler solution that I worked out thanks to this link. I attach it incase anyone's interested.

    Thanks again,
    Jim

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combined point & bar chart (Excel 2000)

    Thanks for sharing that with us.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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