• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    How to use GETPIVOTDATA in a textbox on a graph

    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...
  2. A

    Interesting problem - Excel 2007 Offset formula set for range but returning valu

    Thank you so much for ANY help! Truly your generosity of your time and knowledge is greatly appreciated.
  3. A

    Interesting problem - Excel 2007 Offset formula set for range but returning valu

    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.
  4. A

    Interesting problem - Excel 2007 Offset formula set for range but returning valu

    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.
  5. A

    Interesting problem - Excel 2007 Offset formula set for range but returning valu

    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...
Back
Top