Hello wonderful people of MrExcel,
I am attempting to display an average in a text box for a month (which ever is selected from a slicer),
There are four criteria called movement type also selected from a slicer.
is it possible to display average from data of a pivot chart that goes into an external cell from the pivot chart, that i can link to the text box?
I am only learning excel, a bit each time i use it, so i am probably doing things all wrong!!
I appreciate your time and patience, thank you.
I did try to upload the minisheet, but could not get to work,
the below table on my workbook is a pivot chart
Stefan
I am attempting to display an average in a text box for a month (which ever is selected from a slicer),
There are four criteria called movement type also selected from a slicer.
is it possible to display average from data of a pivot chart that goes into an external cell from the pivot chart, that i can link to the text box?
I am only learning excel, a bit each time i use it, so i am probably doing things all wrong!!
I appreciate your time and patience, thank you.
I did try to upload the minisheet, but could not get to work,
the below table on my workbook is a pivot chart
Stefan
Count of MovementType | Column Labels | ||||
Row Labels | Cancelled | Completed OK | Declined | Ventia Cancelled | Grand Total |
Mar | |||||
1-Mar | 11 | 18 | 3 | 32 | |
2-Mar | 4 | 19 | 6 | 29 | |
3-Mar | 16 | 23 | 1 | 40 | |
4-Mar | 7 | 11 | 18 | ||
5-Mar | 2 | 2 | 4 | ||
7-Mar | 1 | 1 | 2 | ||
8-Mar | 12 | 16 | 2 | 30 | |
9-Mar | 3 | 22 | 2 | 27 | |
10-Mar | 3 | 15 | 3 | 21 | |
11-Mar | 1 | 9 | 5 | 2 | 17 |
12-Mar | 2 | 2 | |||
13-Mar | 2 | 2 | |||
14-Mar | 10 | 23 | 3 | 36 | |
15-Mar | 11 | 14 | 2 | 2 | 29 |
16-Mar | 6 | 20 | 2 | 28 | |
17-Mar | 13 | 17 | 2 | 1 | 33 |
18-Mar | 5 | 13 | 3 | 21 | |
19-Mar | 2 | 2 | |||
21-Mar | 7 | 23 | 2 | 32 | |
22-Mar | 11 | 21 | 4 | 36 | |
23-Mar | 5 | 20 | 3 | 1 | 29 |
24-Mar | 5 | 12 | 3 | 1 | 21 |
25-Mar | 3 | 18 | 1 | 22 | |
26-Mar | 1 | 2 | 3 | ||
28-Mar | 5 | 13 | 1 | 19 | |
29-Mar | 5 | 14 | 4 | 23 | |
30-Mar | 4 | 18 | 1 | 23 | |
31-Mar | 6 | 19 | 25 | ||
Grand Total | 159 | 387 | 53 | 7 | 606 |