pivot chart with offset formula

  • Good Day,

    I have a pivot table., i am trying to insert offset formula for this table.=OFFSET($A$1,,,COUNT($A:$A),12) but when ever i try to do like that the error message Reference Not Valid has displayed. Any idea to resolve this matter ?

    The second problem is in my book I have four sheets in that Exc 1 and Exc 2 sheets are for turnover for different exchanges having date wise data.so what i need is the same data have to be updated automatically in 3 rd sheet that is Both sheet.
    but the problem is here in the Both sheet some of the columns need not to be shown.

    And the third one , Is there any chance to show the different line graphs for total clients individually? (daily data will be added ).
    I am giving my file link here https://www.dropbox.com/s/c7lp0u9cnu...rnover%20.xlsx
    Advanced thanks for your help


    Witson Joyet

  • Re: pivot chart with offset formula

    COUNT() counts numeric data only. I think you need COUNTA()


    Please post the other 2 questions in separate threads as they are 3 different topics.

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!