Can someone help me with how to link the visualisation charts with the underlying data in MS Excel. So the charts are dynamic and coming out indirectly through the pivots using offset function. I wanted to hide working sheet (pivots) and wanted to link the data directly to the chart. So for example: if I have a bar chart showing the number of employees arriving late to the office and data labels on it. Clicking on that particular data labels / number of the late employees should extract the underlying data of who all those employees who come in late as pivot does
0 Answers
Related