First, thanks to everyone who helps!
I'm simply:
1. Inserting a textbox from the Layout tab of the selected graph.
2. Inside of the formula bar, having the text box selected, inserting an '='
3. Then clicking on the Grand Total of a PivotTable
4. This formula appears...
Thank Hui, I understand that. The problem I am having is my formula is returning a single value. Not a range. I have the formula setup correctly yes? What else could be the problem.
Then what do I use to return the range of cells?
I am trying to use Name's to point to a range of cells.
That range will then be used for the series in a chart.
On the tab named "Dashboard" I am playing with the offset function to return a range of rows from the "Missed Time - AD Usage' tab.
=OFFSET('Missed Time - AD Usage'!$B$5,0,1,92,1)
That is the formula I am using. So I am starting at B5, moving 0 rows down, 1 column to the right, the height is...