In this template, percentage values are auto calculated using the numeric values of first two parameters.
Type
Bar Panel Chart
Function
Comparison, Patterns
Use case example: Leads, conversions and percentage conversions
The chart in above example compares and presents number of leads generated, number of conversions and leads to conversion ratio (percentage values) for each of the 5 products.
Also see leads, opportunities and conversions chart template
Formula
% Conversions = (Number of conversions / Number of leads) x 100
How to use and edit this chart template
To edit this chart template, execute following steps.
- Right click on the chart to open chart menu. Click Edit Data. This will open the linked Excel sheet (see video below).
- Enter categories in column A. They are plotted on Y-axis.
- Enter parameter 1 data values in column B. These form the first panel of the chart.
- Enter parameter 2 data values in column C. These form the second panel of the chart.
- The ratio of parameter 1 and parameter 2 is derived from the numeric values. This forms the third panel of the chart.
- Close the Excel sheet.
- File format: PPTX. Compatible with PowerPoint 2013 and above.
