I have a bar chart, consists of two series which will plot side by side.
Both scales are different, ie one is percent and the other dollar values.
I can get one series to have left axis and the other to have right axis however my problem lies in trying to keep both axis zeroed at the same vertical point.
How can this be done?
2 x Bar Series - Diff Scale - Zeroed
I managed to work it out, however not sure if it is the correct method.
Basically I had trouble making sure both left and right axis were "zeroed" at the same vertical point. This needed to happen so that the two bar chart series start from the same point.
Through my data gathering method I returned the absolute maximum value for both series. For the right axis I just set the scale to max out at the maximum right value plus 10%, top and bottom. Repeated the same for the left and what I got was basically two bar series zeroing at the 50% vertical point on the chart.
It works OK, anyone think of something better???
Basically I had trouble making sure both left and right axis were "zeroed" at the same vertical point. This needed to happen so that the two bar chart series start from the same point.
Through my data gathering method I returned the absolute maximum value for both series. For the right axis I just set the scale to max out at the maximum right value plus 10%, top and bottom. Repeated the same for the left and what I got was basically two bar series zeroing at the 50% vertical point on the chart.
It works OK, anyone think of something better???