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?