A series created with data in two workbooks

A

Andrew

Is this even possible?

SERIES("Travel",,('[Milage.xls]2008'!$F$3:$F$42,'[Car.xls]2007'!$F$3:$F$44),2)

I have tryed a number of times with no luck.

Thanks
 
J

Jon Peltier

All data for the Y values of a chart series must be in the same
worksheet. However, the Y values of a series can come from one sheet or
book, and the X values from another. And of course, different series can
come from anywhere.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to store the lengthy value in Series collection? 1
Chart x axis problem 1
Scrabble Value calculation for Welsh words 0
Why can't I see the data labels I just added? 6
Am confused about a simple data layout- need help asap! 1
Charting: Multiple workbooks one chart 3
Create XY (Scatter) Chart, with 3 column (X, Y, Series) 1
Display Name of each Data Series 1

Top