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 |
