Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Line and bar charts with secondary axis
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Line and bar charts with secondary axis
Resolved · Medium Priority · Version 2003
Reply 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?
For upcoming training course dates see: Pricing & availability
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 = 2
As 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
Wed 28 Jan 2009: Automatically marked as resolved.
|