Connecting graph to the source data in the Check Box
Wednesday, January 14, 2009 1:52- 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.
Bill Kay says:
April 17th, 2009 at 9:34 am
sample report using check boxes please bill.kay@boral.com
Thanks
admin says:
April 24th, 2009 at 12:20 am
Bill,
Have mailed to you a sample report on checkboxes as requested. Happy reading!
Cheers!
heyrobertdavis says:
May 13th, 2009 at 4:51 am
Sample report please? Great posts on dashboarding. Thanks!
mike says:
May 24th, 2009 at 5:22 am
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
admin says:
May 27th, 2009 at 6:19 am
Hey Mike, Have mailed the sample report to your id. Thanks for dropping by. Have a great day!
Johny says:
May 28th, 2009 at 5:56 pm
Please send me a sample report, this is a great tip! watt_and_small@hotmail.com
Thanks
admin says:
May 29th, 2009 at 1:58 am
Hey Johny, have mailed the report. Thanks for dropping by.
Ross says:
July 6th, 2009 at 6:15 am
Nice tip. Can I have a copy of the sample report please? Cheers Ross
Mohan says:
July 6th, 2009 at 12:19 pm
Its a puperb one, could you please mail me a sample report
Thanks in advance
Mohan says:
July 6th, 2009 at 12:21 pm
its a brilliant one, could you please mail me a sample report
Thanks in advance
Rashmi Raghunath says:
July 21st, 2009 at 9:18 am
Mail me a sample please.
Jan says:
August 13th, 2009 at 6:04 am
Mail mi sample of this brilliant report plz. Thx!
Dipali says:
August 16th, 2009 at 11:57 pm
Hi,
I m also interested to have this awesome dashboard report. mail me please.
sachin says:
August 18th, 2009 at 7:48 am
i m interested in the report, can u send me Please
Ian says:
August 22nd, 2009 at 2:06 am
could you email me please. Thanks.
Ann Martens says:
September 16th, 2009 at 11:32 pm
Please send me a sample report utilizing checkboxes in graphs.
admin says:
September 17th, 2009 at 1:43 am
Have mailed the sample. Please mail back for any clarification. Thank you for reading the Nabler team blog. Keep coming back for more updates.
Nielsen says:
October 11th, 2009 at 12:05 pm
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.
Jay says:
November 5th, 2009 at 2:34 pm
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
Peter says:
November 23rd, 2009 at 5:52 pm
Hi, Great Report. Please email me the example. Thanks
joão says:
December 4th, 2009 at 7:47 am
from Portugal
Please send me a sample report… Thank´s