Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Stacked bar chart to show ranges (2003)

    I've been asked to create a stacked bar chart to show salary ranges for 3 job titles compared with the same job titles at 2 other companies.

    CSR = $14 - $22 at company 1
    CSR = $16 - $22 at company 2
    CSR = $10 - $16 at company 3
    CSRLead = $18 - $22 at company 1
    (no other companies have this position, but I need to show it for company 1)
    CA = $23 - $26 at company 1
    CA = $23 - $26 at company 2
    CA = $18 - $22 at company 3

    The requestor wants the companies as the X axis
    Job tiles show once for each company (as a range)
    Salary shows as the Y axis in $2 increments

    I have no idea how to do even set up the data source so it will display the data as a range, not show each job title separately.

    Can you tell me how to set this up, please?

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

    Re: Stacked bar chart to show ranges (2003)

    The attached sample workbook uses the method from How to create charts with multiple groups of stacked bars in Excel 2000.
    Attached Files Attached Files

Posting Permissions

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