Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Posts
    309
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Comparative Chart (Excel 2002)

    Please review the attachment I sent. I need to create a comparative chart using the data in the spreadsheet. (A1:C8). I tried to draw the chart manually so you can see what I need.. Thanks for your help ahead of time.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Comparative Chart (Excel 2002)

    You did not attach a file.

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Mar 2001
    Posts
    309
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comparative Chart (Excel 2002)

    <P ID="nt"><font size=-1>(No Text)</font>

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Comparative Chart (Excel 2002)

    Just use a stacked bar and use Negative numbers for the female values

    Steve

  5. #5
    3 Star Lounger
    Join Date
    Mar 2001
    Posts
    309
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comparative Chart (Excel 2002)

    If I change the female to - numbers the x-axis shows -40% -30% and so on. Also I loss the Y-axis numbers???? Need more instructions please...

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Comparative Chart (Excel 2002)

    1) Change the format of the X-Axis:
    Dbl-click x-axis, numbers tab, category custom, (no quotes) "0%;0%"

    2) Y-axis labels are in the center move them:
    dbl-click y-Axis (center line), Patterns tab; check "tick mark labels" LOW

    Not asked by also FYI,
    3) you can change the "space" between the bars: (essentially "widening the bars")
    dbl-click one of the series, options tab, set "gap width" to desired level.

    Steve

  7. #7
    Lounger
    Join Date
    Feb 2004
    Location
    Buffalo, New York, Wales
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comparative Chart (Excel 2002)

    Your graph and identical numbers are taken from the book "Excel 2002 Formulas" by John Walkenbach, page 452.

Posting Permissions

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