We help IT Professionals succeed at work.

Text Range References in Chart SERIES Formula

bvallanc
bvallanc asked
on
I have a scatter chart for which I want to use text range references (e.g., $AC$30:$AF$58) as the x-value and y-value ranges in the chart's SERIES formula.  Said another way, I have text strings in cells that I want to use as the x and y values for the chart's SERIES formula.  I can't for the life of me figure out the syntax to make this work.

In the attached file I want to use the "X-VALUES:" and "Y-VALUES:" "built-up" range text as the x and y values, respectively, for the chart's SERIES formula.

Anyboby know how this can be done?

Thanks,

Bill Vallance
Chart-SERIES-Formula-Example.xlsx
Comment
Watch Question

Cost Accountant
CERTIFIED EXPERT
Top Expert 2012
Commented:
OK...

1) Using Formula > Named ranges add two ranges using the Indirect formula

Then on the chart data

2) edit the range and delete the range (but not sheet part of the formula) press F3, select the named range.

See attached return...
Chart-SERIES-Formula-Example.xlsx

Author

Commented:
Barman,

Your solution worked perfectly!  Thanks for the quick response.

Bill Vallance

Explore More ContentExplore courses, solutions, and other research materials related to this topic.