To change the background of the document, you need to go to the same section, just select the topmost item Chart style – Background color . An entire document or a single cell can be colored using a fill. Color alternation When the colors of the cells alternate, the information is a little easier to perceive. To do this, select the desired range or column, go to the Format – Alternation section and select the desired colors. 20+ reports that will help you evaluate the return on advertising. Analyze how campaigns are performing and redistribute the budget in favor of the most successful ones.
- Understanding how to optimize ads. Reports will show which sources, channels, campaigns and keywords are working. Audio recordings of calls will help to understand what information buyers are missing in ads.
- Automatic calculation of advertising payback. End-to-end analytics will show income from launched activities and calculate ROI for them.
Create chart on checkbox click
- Simple and fast bid management. Analyze current rates, find out their recommended size and apply with one click right in Ringostat.
A checkbox or checkbox is a square area that, when clicked, puts a marker. For example, checkbox. You can make it so that the graph is automatically built depending on which checkboxes are activated.
Let’s take an example. The above document Albania Email List contains the following:
MQL – all incoming leads for which there were no open deals before; SQL – leads that the sales department considered to be of high quality: the visitor made a relevant request, this is not spam, the manager was able to contact the person, etc.; Won — won trades;
Let’s say we want to see how the number of MQLs
Has changed over the year, compare them with the number of SQL and won deals. To do this, we make only three clicks, and we get the finished chart:
How to do it? Select the desired range, column, row or cell with the mouse. Click on the tab Insert – Checkbox , and the entire selected area will be converted into checkboxes.
In order for charts to be built when clicking on them, you need to use formulas. If you move the graph to the side in the sample document, you will see something like this below it:
When one of the checkboxes is selected, the corresponding box in the red-circled area changes to TRUE. The data is copied from the specified range, and thus a graph is built.
The bottom row of numbers contains a formula that specifies the string, its status, and range. For example: