Using a Named Reference in Chart Series 1

[TulsaJeff]

I have approximately 13 charts(one per dept)I am wanting to use a named reference in the Category axis.

I now have the following formula:

=SERIES("Labor",'[Maap Absorption Analysis.xls]Labor + TLabor'!$A$6:$A$20,'[Maap Absorption Analysis.xls]Labor + TLabor'!$B$6:$B$20,1)

the bolded reference needs to be "DateRange"

Anyone know the correct format on this? Ya' Gotta Love It!

 

[SkipVought]

Jeff,
Charts are tricky.

Here's what I did...
In the Chart Wizard in the Series Tab, I used Range Names, BUT...
ya hafta keep the workbook reference. So mine looked like...

=Book1!Range1

And I not only named my data ranges, but also my heading...

=Book1!hdgRange1

So, here's what the SERIES looks like in the Fulmula Bar...

=SERIES(Book1!hdgRange1,Book1!List1,Book1!Range1,1)

Hope this helps Skip,
metzgsk@voughtaircraft.com

 

[TulsaJeff]

Ok, I am not sure I understand completely... can you explain and demonstrate using my references so I can understand what you are referring to....

=SERIES("Labor",'[Maap Absorption Analysis.xls]Labor + TLabor'!$A$6:$A$20,'[Maap Absorption Analysis.xls]Labor + TLabor'!$B$6:$B$20,1)

I tried doing it the way I thought you said but it keeps telling me my formulas are incorrect. I noticed you did not have the brackets around your workbook names.. how are you accomplishing that?

What do you mean by heading? Is that the legend?

I am a little confused as if you can't tell...

Thanks for the help! Ya' Gotta Love It!

 

[SkipVought]

here are my ranges in a saved workbook...

=SERIES('767 SECT 48 MBOM MASS rev-B.xls'!hdgRange1, _
        '767 SECT 48 MBOM MASS rev-B.xls'!List1, _
        '767 SECT 48 MBOM MASS rev-B.xls'!Range1,1)

Here's what I think your would look like if I am understanding what you want...

=SERIES("Labor", _
        'Maap Absorption Analysis.xls'!DateRange,
        'Maap Absorption Analysis.xls'!$B$6:$B$20,1)

Hope this helps Skip,
metzgsk@voughtaircraft.com