nparsons75
Well-known Member
- Joined
- Sep 23, 2013
- Messages
- 1,254
- Office Version
- 2016
Hi, I have a chart, basic column chart. I have a table of data that feeds the chart. The table uses filters and I would like the chart to work dynamically with the filters. For example, if I filter to show on march data, the chart will change and show chart data. I have tried unticking 'show data in hidden rows' but this just shows gaps, I need them gaps to supress.
Any ideas, appreciate the help.
Any ideas, appreciate the help.