MultiColumnDualY Negative values throws chart off balance
The bars are ok to be negative, but not the line (dual y).
For Ex.
Xaxis is Hours
Primary Y axis has negative sales
Secondary Y axis is suppose to start at 0, Percentage Based, so when you have negative values this %=100, so should not be negative value.
But then the chart is misaligned, I tried playing with min / max values, didn't go, is their a way to set the min value of Secondary Y Axis to min value of Primary Y axis.
thanks
XML of what i am doing. ignore numbers, i know this example is not percentage based, but you get the idea.
[ code ]
[/ code ]
sparkXML.xml