| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Sergv
It does seem to work for me if I do the following Assume data is in a range A1:C2 on Sheet1 in file Book1.xls Jan | Feb | March 123 | 234 | 345 Define the following names myGraph=OFFSET(Sheet1!$A$1, 1,0, 1, COUNTA(Sheet1!$2:$2)) myTitle=OFFSET(mygraph,-1,0) Then set up your graph Series1=SERIES(,'Book1.xls'!myTitle,'Book1.xls'!my Graph,1) Post back if you still have problems hth RES |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic charting | Excel Discussion (Misc queries) | |||
| Can't create dynamic charts | Charts and Charting in Excel | |||
| Charting with dynamic data | Charts and Charting in Excel | |||
| excel dynamic charting | Excel Discussion (Misc queries) | |||
| Dynamic charting problems (events) | Charts and Charting in Excel | |||
Threaded Mode
