| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formulas in chart series references
Does anyone know if it possible to have formulas embedded in the SERIES
formula that defines a chart series. For example, what I'd like to have is =SERIES(Sheet1!$C$18,Sheet1!$D$16:$F$16,INDIRECT(D 12),1) where D12 is a valid text range. This does not seem to work. Essentially, I am trying to set up the chart so I can toggle what is charted without needing to alter the chart references OR set up a separate set of cells that are charted and that in turn refer to the (changing) data set I want to chart. Any thoughts are welcome! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
| How to change Series order in a Combination Chart? | Charts and Charting in Excel | |||
| How to change Series Order in a Combination Chart? | Excel Discussion (Misc queries) | |||
| Dynamic series in Chart | Charts and Charting in Excel | |||
| Help! I'm losing one series of data in an overlay chart. | Charts and Charting in Excel | |||
Threaded Mode
