- contributed by Gunjan Aggarwal
First of all, Thank you, Mukesh, for your interest, and the comment on check boxes and combo boxes blog post. This post is the answer to your question about linking the graph to the source data. Hope this would answer your query!
Graph with check box option
Source data for the graph
Above is the Graph using Check Box and its source data below.
Source Data: In the source data formula will be written for which the control will be assigned to a particular cell on the Dashboard page.
Formula given in data source
Control cell in dashboard
Explanation of the formula used for paid search Section:
=if(Dashboard!$A$4, Sheet2!C5,NA()) :
If DASHBOARD sheet cell no. A4 is TRUE, then give the value in Sheet2 cell no. C5, else NA. The formula is written in the same way for the rest of the sections i.e., Direct Traffic, Organic Search Emails… etc and finally it is selected as the source data for the graph on the Dashboard.
If you need a sample report on any of these dashboard tricks, please leave your email id in a comment. And we will mail it over to you.
sample report using check boxes please bill.kay@boral.com
Thanks
Bill,
Have mailed to you a sample report on checkboxes as requested. Happy reading!
Cheers!
Sample report please? Great posts on dashboarding. Thanks!
Great place to deep on Excel knowledge.
It’d be interesting if you could send me a sample report with these dashboard tricks.
Thanks in advance.
Mike
Hey Mike, Have mailed the sample report to your id. Thanks for dropping by. Have a great day!
Please send me a sample report, this is a great tip! watt_and_small@hotmail.com
Thanks
Hey Johny, have mailed the report. Thanks for dropping by.
Nice tip. Can I have a copy of the sample report please? Cheers Ross
Its a puperb one, could you please mail me a sample report
Thanks in advance
its a brilliant one, could you please mail me a sample report
Thanks in advance
Mail me a sample please.
Mail mi sample of this brilliant report plz. Thx!
Hi,
I m also interested to have this awesome dashboard report. mail me please.
i m interested in the report, can u send me Please
could you email me please. Thanks.
Please send me a sample report utilizing checkboxes in graphs.
Have mailed the sample. Please mail back for any clarification. Thank you for reading the Nabler team blog. Keep coming back for more updates.
Sir,
I have tried my best to implemet the checkbox and combo box trick but it wont work.
Could I ask you kindly to send me the sample, and thanks for the site.
Hi Admin,
Please could you E mail me a copy of your report.
Great work by the way.
Will you be providing more posts on Excel ? Would be greatr if you do-
Regards
J
Hi, Great Report. Please email me the example. Thanks
from Portugal
Please send me a sample report… Thank´s
Please send me a sample report, this is a great tip!
Any chance I can get a copy of this report too? many thanks
Can i please have a copy of a samplpe report. I have been trying to do this for days….
Thanks
May i please get a copy of the sample graph
Please send me a copy of this example.
Kindly,
Jose