Indirect Named Range in a Scatter Graph

Hello,

what error message do you get?

When you enter the range name in the series dialog, you must precede the range name with the sheet name or the workbook name, for example

=Sheet1!MyXValues

RangeNamesInXYSeriesDialog.gif

When you edit the series you will see that Excel has changed the sheet name reference to the workbook name.

cheers, teylyn

you need to post example file so we can see the actual formula you have used and whether it's valid.

First, see my previous post about preceding range names with the sheet name when using it in a chart series reference.

Once you have sorted that, note that this error message comes up when a range name used in a chart returns an error. You need to ensure that all range names return valid ranges or values.

Open the Name Manager, select each range name in turn. Click into the formula box (below the list of range names, where the formula for the currently selected range name is showing). When you do so, the corresponding range of the workbook should come into focus and should show the "marching ants" around the range. If that does not happen, the formula is not valid and needs to be corrected.