| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
A series created with data in two workbooks
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
A series created with data in two workbooks
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 ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Andrew wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I delete an already created series of check boxes? | Excel Discussion (Misc queries) | |||
| How to get sum of data in series from 2 Workbooks to another Workbook | Links and Linking in Excel | |||
| Add series names to legend after the chart has been created | Charts and Charting in Excel | |||
| How do I use a micro created in one workbook in other workbooks? | Excel Worksheet Functions | |||
| I've created a custom fill series. Now I don't know how to use i. | Excel Discussion (Misc queries) | |||
Hybrid Mode
