Fri 16 Jan 2009, 15:10Delegate Katy said...
Katy has attended:
Excel VBA Advanced course
Line and bar charts with secondary axis
In VB what code do I need to create a chart with a secondary axis? Once created how then can I change the chart type for the data on the primary axis to a bar chart and the data on the secondary axis to a line chart?
Wed 21 Jan 2009, 15:43Trainer Stephen said...
RE: Line and bar charts with secondary axis
Hi Katy
Thankyou for your question
After some experimenting i have found the following code snippet which selects a series in a chart and then plots it against a secondary axis
ActiveChart.SeriesCollection(5).Select
ActiveChart.SeriesCollection(5).AxisGroup = 2As you can see the series is identified by its index number in the collection and then sets the axisgroup property to 2
Hope this helps
Regards
Stephen
