HI all,
I have a workbook that crates a group of charts on a single worksheet. Each chart is based on 39 weeks' of data, but I want to show the last 8 weeks only, or be able to switch all the charts to show week 7, 15, 22 etc (it is school data, so weekly for now, but eventually the end of each half-term). I can do this manually by selecting each chart, right-clicking on it and clicking "select data", then in the dialogue box switching each week on or off manually. Can this be done in VBA code? If so, how do I access the chart properties? Can I do it through the chart.categorycollection route? there are twenty charts, so automating this woudl be great, especially as someone else with only operational excel skills will use the workbook. Any help appreciated.
JPL
I have a workbook that crates a group of charts on a single worksheet. Each chart is based on 39 weeks' of data, but I want to show the last 8 weeks only, or be able to switch all the charts to show week 7, 15, 22 etc (it is school data, so weekly for now, but eventually the end of each half-term). I can do this manually by selecting each chart, right-clicking on it and clicking "select data", then in the dialogue box switching each week on or off manually. Can this be done in VBA code? If so, how do I access the chart properties? Can I do it through the chart.categorycollection route? there are twenty charts, so automating this woudl be great, especially as someone else with only operational excel skills will use the workbook. Any help appreciated.
JPL
