Results 1 to 2 of 2
Thread: Secondary Axis (2003 sp1)
2005-04-11, 16:43 #1
- 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.
2005-04-11, 18:49 #2
- 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.