Forum

Notifications
Clear all

Control Charts from a Pivot Table??

2 Posts
2 Users
0 Reactions
657 Views
(@gibsonteddyj)
Posts: 3
Active Member
Topic starter
 

I'm not certain that I have this question placed in the correct location, but congratulations to whichever topic it lands in...

 

Can anyone out there tell me if its possible to create a dynamic control chart using a pivot table?

 

Many thanks for any advice,

 

Teddy

 
Posted : 02/08/2018 4:02 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Teddy,

I'm not sure what your definition of a dynamic control chart is, but you can use Pivot Charts and Slicers to dynamically filter the view of the chart as described here: https://www.myonlinetraininghub.com/excel-pivot-charts

And this link will take you to more examples of Slicers in use.

Mynda

 
Posted : 02/08/2018 6:54 pm
Share: