Question

How the working of a dashboard after creating a suitable data look like and in dashboard slicers and graphs must be properly connected and workable.

Answer 1

Answer:

so sorry mate

I need a help!!!

Answer 2

Answer:

This technique is simple but there are a lot of steps, so a quick outline of where we're going should be beneficial:

The data is in a Table object, but that isn't strictly necessary.

We'll create two PivotTable objects: one for viewing sales by region and one for viewing sales by quarter.

We'll generate a PivotChart for each PivotTable object.

We'll add a Slicer for each chart.

We'll copy everything to a Dashboard sheet.

Don't worry if you don't know how to create a PivotTable or PivotChart. I'll provide all the necessary steps to create the simple dashboard shown in Figure A. The data set is simple on purpose, but you can use as many settings as you need to meet more complex requirements