Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Melbourne, Fl USA
    Thanked 0 Times in 0 Posts

    Secondary Axis (2003 sp1)

    I have charted the NCO data from the Totals sheet to the Avg NCO sheet. I'm trying to add the ABA % data from the Totals sheet to each monthly chart on a secondary axis (as just a line). I see the data labels (on the January chart and the yearly one at the bottom of the sheet) but no line. I've been playing with the values, but just can't see to get it right. Can anyone help please? I'd like to learn to do this myself, but i'm lost. Thanks in advance.

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

    Re: Secondary Axis (2003 sp1)

    The problem is trying to select the data range since it is so much smaller than the range in the NCO.

    Dbl-click the y-axis and set the max to 1
    Now you can see the ABA data.
    Right-click an item in this range and set to chart-type line
    dbl-click and set axis to secondary
    [If you need more step-by-step details, let me know]
    After you put it onto the sec-axis, you can dlb-click the left y-axis and reset the max.


Posting Permissions

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