Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Trouble with named data
In the formula bar of an x-y chart, I entered:
=SERIES(,'Sheet1'!xData,'Sheet1'!yData,1) I tried both with and without the single quotes around Sheet1 -- either way I get an error message indicating the formula contains an invalid external reference. How can I solve the problem? It should be indicated: 1) xData and yData both contain an INDIRECT function whose text argument is a relative reference, thus data depends on which is the active cell. (I select a cell and recalculate in order to plot different sets of data). 2) This method of charting DID work for me before; something is a little different about the way I'm doing it. 3) xData and yData DO presently return correct values when entered as arguments in a cell (e.g., SUM(xData)). |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Trouble with named data
I've had mixed results using INDIRECT in name definitions when the names are
used as chart series data. I guess charts aren't as smart as worksheets when reading data from names. Sometimes it works (as in a little test I just did), and sometimes it doesn't. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "hmm" wrote in message ... In the formula bar of an x-y chart, I entered: =SERIES(,'Sheet1'!xData,'Sheet1'!yData,1) I tried both with and without the single quotes around Sheet1 -- either way I get an error message indicating the formula contains an invalid external reference. How can I solve the problem? It should be indicated: 1) xData and yData both contain an INDIRECT function whose text argument is a relative reference, thus data depends on which is the active cell. (I select a cell and recalculate in order to plot different sets of data). 2) This method of charting DID work for me before; something is a little different about the way I'm doing it. 3) xData and yData DO presently return correct values when entered as arguments in a cell (e.g., SUM(xData)). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble With Data Validation And Filtering On A Dropdown | Excel Worksheet Functions | |||
Trouble with selecting multiple ranges of data | Excel Worksheet Functions | |||
trouble ranking data... | Excel Discussion (Misc queries) | |||
Trouble formatting Date data | Charts and Charting in Excel | |||
EXCEL2000 trouble with SUM function recalculating on new data ent | Excel Worksheet Functions |