Posted by: admin
Category: Advanced, Tips and Tricks
Tags: check box connecting data source, check box in graph, connecting graph to source data in check box
Connecting graph to the source data in the Check Box
- 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.
Follow us