If you want to create a video advertisement cost calculator with a bar chart summarising different costs per quality, you are in the right place. With our table-based graphing feature, you can easily create such a calculator. Let's get started!
How to get started with configuring the Graph
A. Open the respective content in Build mode and navigate to the Results page.
B. On the Results page, navigate to to Add Media section, and click on the Chart option.
C. Our tables work just like any other spreadsheet. Start inputting numbers or variables in the cells, and the graph will start building automatically on the side. You can use variables from the calculator in the spreadsheet cells, like R1, R2, Q1, Q2, etc. When the graph is created for the end-user, it will automatically fetch the numbers for the variables.
NOTE: You can also click on Upload Excel, and upload an existing Excel sheet that you might have containing all the required information.
Using Variables
The format for writing the variables is slightly different. Instead of writing R1, you need to add an underscore. So it will be R_1 and Q_1.
Also, remember to add a "=" before referring to a variable.
A. You can do most mathematical operations inside of the table.
B. You can easily change the graph type by selecting it from the left panel. The graph will automatically adjust to take the numbers.
C. Just click on the settings tab to make aesthetic changes like adding colours and grids, etc.
D. Click on Insert Chart to add the chart on the Results page.
Important Note
Sometimes, when Conditional Media is enabled on the results page, you cannot add Charts & Graphs, as Conditional Media only supports Images and Videos. You can turn off the Conditional Media setting, after which you can see the option to add charts and graphs.
Feel free to email support@outgrow.co if you need any help with the formula. We will be delighted to help :)
โ