Sales Funnel using a pivot Chart

montrof
montrof used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Awarded 2010

Commented:
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

Author

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

Montrof
Most Valuable Expert 2011
Awarded 2010
Commented:
So, point the chart data source to the pivot table. You can build a regular chart with data that is in a pivot table.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial