How to Export an Editable Funnel Chart to PowerPoint – Displayr Help

Displayr's visualization options contain a funnel chart type. However, this particular visualization can only be exported as an image. This article describes how to create a funnel chart that can be exported as an editable PowerPoint chart.

It contains the steps to go from the table like below:

to an editable funnel PowerPoint chart:

Requirements

A table containing data for the Funnel chart.

Method

The method involves creating a stacked bar chart where filler data is paired with the My Brand funnel data. The two filler portions on each side of the actual funnel data are colored white so it appears the actual colored funnel portion is centered.

First, we will need to create a new table using R with the filler data calculated. Go to Calculation > Custom Code and click onto the Page to place the object.

Update and input the below code into R Code editor:

# Replace table.output with the name of your table 
mytable = table.output
# calculate the difference to 100%
fill = (100 - mytable) / 2
#combine the columns and return the final table
final = cbind(fill, mytable, fill)
#make statistic of table % for percentage data labels in PPT
attr(final,"statistic")="%"
#return final table
final

Your output should look like the table on the right, with the middle row containing the source funnel data, and each row sums up to 100.

We will use this table as an input to the stacked bar chart. Select the Calculation table and go to Visualization > Bar > Stacked Bar.
Go to Chart > Legend > Legend > Hide.
Next, select Chart > Data Series > Color palette > Custom palette (color pickers).
Set the first and the third color to No fill. Set the second color to the color of your funnel.
OPTIONAL: To remove the axis labels go to Chart > Values (X) Axis and deselect Show axis labels.
OPTIONAL: To remove the grid lines go to Chart > Values (X) Axis > Grid Line Width and set the value to 0.
Go to Properties > PowerPoint Export > Format and select Microsoft Chart.
To export the chart, go to Share > Export Report > PowerPoint.
Select Export Selected Page(s) from the dropdown and click Export.
Open the PowerPoint export and apply any other desired formatting changes to the chart (e.g. right-click on the colored bars and Add Data Labels).