dwg83
Board Regular
- Joined
- Nov 8, 2006
- Messages
- 174
I originally had a chart utility tool that allowed me to toggle series between primary and secondary. All the series were xyscatteredsmooth which is likely why I never had an issue toggling back and forth as long as one series was on the primary axis.
In an effort to be more fancy, I wanted to introduce columnclustered into the mix, but am coming up with “Method 'AxisGroup' of object 'Series' failed” when trying to switch the column chart back to primary. I see also that the options are greyed out when I try to do through excel. I know I can have a column and scattered on one y axis, but why can I not switch from secondary to primary?
The line of code used to switch y axes is
I know I am having scaling issues too.
Thanks in advance!
In an effort to be more fancy, I wanted to introduce columnclustered into the mix, but am coming up with “Method 'AxisGroup' of object 'Series' failed” when trying to switch the column chart back to primary. I see also that the options are greyed out when I try to do through excel. I know I can have a column and scattered on one y axis, but why can I not switch from secondary to primary?
The line of code used to switch y axes is
Code:
ActiveChart.SeriesCollection(punk).AxisGroup = 1
I know I am having scaling issues too.
Thanks in advance!
Last edited: