My customer wants a bar chart with several line series across the bars. To do this I had to resort to two charts* -- one side-by-side bar and one line chart SUPERIMPOSED one on the other. The foreground chart has transparent background, axes and scales. By careful alignment, I can get the borders of the 2 charts to line up exactly.
The problem now is how to synchronize the scales of the two charts; I had thought that by plotting the same values on both charts (and hiding the ones I dont want to see), the scales would automatically be set to the same max values. This is not the case. The max value for the line chart is consistently lower, in one instance 40% lower.
Do you know of a scheme to synch these scales?
* A combo chart would allow me to add only one line series without plotting cumulative values.
IP Logged
