• 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.

Progresive Monthly report / Dashboard

RobSA

RobSA

Member
Hi folks,


I am building my first Dashboard which is to be used as a reporting tool on a monthly basis, there is however sections of data that need to appear that acumulate as the year develops.


I therefore need to develop the page that when I select February fro example, the combined data for Jan & Feb will be posted. Similarly if I select June then the information up to June will be shown.


I hope there is someone that can help


Regards Rob
 
You can either setup an area adjacent to the data for the cumulative data or use named Ranges which will accumulate data
 
Hi Hui,


I have posted the file at this link https://spreadsheets.google.com/spreadsheet/ccc?key=0Ahe_P6TwosJTdEF1YTZ4MS1pV0NDbGV4eE8xQmozWlE&hl=en_US&authkey=CInJo-8I


My first objective is to increase the text size in the list box to be nearly similar to that seen adjacent to it.


The list box ideally should have the function that when I select the month the information up to that month will appear in the middle graph and right hand graph.


If I slect the month then the information for January will appear in the first graph on the left hand side.


I hope this makes sense and that it is possible to do this excercise


Regards

Rob
 
You must log in or register to reply here.
Back
Top