Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 285
  • Last Modified:

Text Range References in Chart SERIES Formula

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
0
bvallanc
Asked:
bvallanc
1 Solution
 
SteveCommented:
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
0
 
bvallancAuthor Commented:
Barman,

Your solution worked perfectly!  Thanks for the quick response.

Bill Vallance
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now