جمعه دهم مرداد ۱۳۹۹ - 1:34 - حسين حسين پور -
You can turn any Pivot Table into a chart easily. With the power of Slicers and Timelines, you can quickly create interactive charts in Excel. Such charts provide intuitive and awesome experience to your users.
To create an interactive pivot chart:
- Create a regular pivot chart (you can add one from a pivot table or create a pivot chart directly from your data)
- Add a slicer or timeline
- Now the chart will change every-time you interact with the slicer.
Pro tip: Multiple slicer + chart combinationsYou can link more than one slicer to a chart and more than one chart to a slicer. This can create truly immersive and powerful analytics for your business.