Link to home
Start Free TrialLog in
Avatar of montrof
montrofFlag for United States of America

asked on

Sales Funnel using a pivot Chart

I have been using the following methodology to create a sales funnel chart  but the problem is that I need to do it from a pivot table, Please provide any ideas.

http://www.exceldashboardtemplates.com/how-to-make-a-better-excel-sales-pipeline-or-sales-funnel-chart/

Thanks,
Montrof
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Hello,

you can build the chart in exactly the same way as described in that blog. Just use a regular chart, not a pivot chart.

cheers, teylyn
Avatar of montrof

ASKER

I get that but the data I am using is in a pivot table.

Montrof
ASKER CERTIFIED SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial