Can we create a Bar Graph with 2 Y axis & ensure the 0 is at same level
The units/counts of the 2 Y axis is different.
Chart 1- X axis Territory ( Region Names)
Y axis Budget ( $ amounts,can be negative)
Chart 2- X axis Territory (Region Names)
Y Axis Quota Allotted( Products Quota, not a negative value)
If we merge the 2 charts and have the Common X axis, we need to see the result with 2 Y axes & 1 X- axes
We tried doing this in Chart Canvas, but the 2nd Y axis had a different 0 starting from bottom of the chart & not matching where the 0 for 1st Y axis was.
Please suggest a solution