AmplifyMike
New Member
- Joined
- Sep 4, 2019
- Messages
- 2
Hello everyone. I need some help on this one. I have a data set that is 12 rows x 16 columns. I am Trying to write code that will filter the Horizontal (Category) Axis Labels visible when I chart the data. I have code to filter the Legend Entries (Series) on the chart, but the X-axis seems to be giving me a lot more trouble. Here is the code I used to change the displayed Series, just cycle the False value for each of the series 1-11:
Thanks in advance.
Code:
Sub Channel_Alternative()
'
' Channel Alternative Macro
'
'
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.FullSeriesCollection(1).IsFiltered = False
ActiveChart.FullSeriesCollection(2).IsFiltered = True
ActiveChart.FullSeriesCollection(3).IsFiltered = True
ActiveChart.FullSeriesCollection(4).IsFiltered = True
ActiveChart.FullSeriesCollection(5).IsFiltered = True
ActiveChart.FullSeriesCollection(6).IsFiltered = True
ActiveChart.FullSeriesCollection(7).IsFiltered = True
ActiveChart.FullSeriesCollection(8).IsFiltered = True
ActiveChart.FullSeriesCollection(9).IsFiltered = True
ActiveChart.FullSeriesCollection(10).IsFiltered = True
ActiveChart.FullSeriesCollection(11).IsFiltered = True
Thanks in advance.