Chart Series Refers to

[ilcaa]

Is it mandatory to have the SheetName! in the Chart 'Series Value' refers to. If I use a named range does Sheet Name need to be included in Refers To if I plan to use it in a chart

OR, is there a way to use Relative Range Names in Chart 'Series Values' it seems like I need to create the Series Value for each Sheet even though they all have same Relative Range (its Dynamic Array)

so each sheet has a spilled array in H64. i was hopeing to define a name "myValues": !$H$64# and just use 'myValues' in each Chart for each Sheet... a little insight or best practices for this case.

 

[Jon Peltier]

The range addresses in the chart SERIES formula require a reference to the parent worksheet of the range. These must be absolute addresses; if you enter a relative address, Excel inserts the dollar signs.

In the case of Names, if the Name has a local (worksheet) scope, the worksheet name must prefix the Name in the formula. If the Name has a global (workbook) scope, then the workbook name must prefix the Name; if you enter the worksheet name for a global Name, Excel converts it to the workbook name.

The formula editor will choke on a SERIES formula with a Dynamic Array hash reference.