Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Etobicoke, Ontario, Canada
    Posts
    198
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multi Scale in Line Chart (9.0.6926 (SP-3))

    I'm tracking 6 items over a calender year. 5 items are in the 0 - 20,000 range while 1 item is in the 120,000 - 200,000 range. How can I make these items appear on 1 line chart without having the 5 jammed at the bottom so close together that you can't see their increases & decreases. <img src=/S/please.gif border=0 alt=please width=31 height=23>

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

    Re: Multi Scale in Line Chart (9.0.6926 (SP-3))

    Create the chart.
    Double click the series that is in the 120,000-200,000 range.
    This will open the Format Series dialog. Activate the Axis tab.
    Select Secundary Axis.
    Click OK.

  3. #3
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Etobicoke, Ontario, Canada
    Posts
    198
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi Scale in Line Chart (9.0.6926 (SP-3))

    That was TOO easy! I guess I could have also "nested" 2 charts, one above the other?

  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: Multi Scale in Line Chart (9.0.6926 (SP-3))

    If you want to get "fancy", you could try one of Jon Peltier's tricks to make a broken y-Axis to have a gap between the low values and the higher values.

    Steve

  5. #5
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Etobicoke, Ontario, Canada
    Posts
    198
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi Scale in Line Chart (9.0.6926 (SP-3))

    WOW! Another great bookmark! Thanks <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

Posting Permissions

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