I have a spreadsheet that houses key metrics for my business and I'm trying to visualize data like "1st meetings held, business closed, referrals received" etc. with a pivot chart. I can show the data in a graph all together but there's no way for me to toggle specific data on/off. It would be great if I could have that setup in a slicer type interface. Here's the chart: Pasteboard — Uploaded Image Here's the table I'm sourcing the pivot table/chart from: Pasteboard — Uploaded Image Again, ideally I'd like to be able to toggle on any of the metrics from the source table. This would allow me to benchmark one metric vs a goal metric or multiple at the same time. Let me know if you need further clarification - thanks in advance for your help on this!

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Pivot Chart that can toggle on different metrics?

Thread starter dpill
Start date Mar 14, 2017

dpill

New Member

Mar 14, 2017

[FONT=&quot]I have a spreadsheet that houses key metrics for my business and I'm trying to visualize data like "1st meetings held, business closed, referrals received" etc. with a pivot chart. I can show the data in a graph all together but there's no way for me to toggle specific data on/off. It would be great if I could have that setup in a slicer type interface.

Here's the chart:[/FONT]
[FONT=&quot]Pasteboard — Uploaded Image[/FONT]
[FONT=&quot]Here's the table I'm sourcing the pivot table/chart from:[/FONT]
[FONT=&quot]Pasteboard — Uploaded Image

[/FONT]
[FONT=&quot]Again, ideally I'd like to be able to toggle on any of the metrics from the source table. This would allow me to benchmark one metric vs a goal metric or multiple at the same time.

Let me know if you need further clarification - thanks in advance for your help on this![/FONT]