A
amurphy1
I am stumped and have tried without any joy to get this working. I
have summary by month graph that I need to see a primary vs
comparision years with credits debits and counts for each.
Have got everything working except the secondary y scale.
I have 6 series - 4 column and 2 line graphs. The line graphs are set
against the secondary axis.
The becauase I want to show + and - values and the secondary axis must
also start in the middle (rather than at the bottom which would look
silly) - I have released that I must set the max and min values of the
axis.
I am using the following code to set the primary axis:
With Me.ChartSmmryByMnth
.Axes(2).MaximumScale= x
BUT - if I try to set .axes(3) - I get the following errorL
ERROR 1004 - "unable to get the axes property of the chart class"
I have read from other forums that it is because of nulls in the data
set - which is not the case in this example.
Also that a the axis of a line series cannot set - have tried changing
the series type to column and changing it after - to no avail.
Can anyone shed any light on this? Any tips would be welcomed warmly!
Many thanks
Andrew
have summary by month graph that I need to see a primary vs
comparision years with credits debits and counts for each.
Have got everything working except the secondary y scale.
I have 6 series - 4 column and 2 line graphs. The line graphs are set
against the secondary axis.
The becauase I want to show + and - values and the secondary axis must
also start in the middle (rather than at the bottom which would look
silly) - I have released that I must set the max and min values of the
axis.
I am using the following code to set the primary axis:
With Me.ChartSmmryByMnth
.Axes(2).MaximumScale= x
BUT - if I try to set .axes(3) - I get the following errorL
ERROR 1004 - "unable to get the axes property of the chart class"
I have read from other forums that it is because of nulls in the data
set - which is not the case in this example.
Also that a the axis of a line series cannot set - have tried changing
the series type to column and changing it after - to no avail.
Can anyone shed any light on this? Any tips would be welcomed warmly!
Many thanks
Andrew