Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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)). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |