Hi guys
This issue at first seemed really simple but I have been at this for hours and cannot make any progress. I have search a ton of articles, boards and all the solutions posed do not fix the issue i am facing, which is to place the secondary Y axis (which is a calculated field, showing only negative values) underneath the X axis. Instead, excel is placing the Y axis on the same level as the primary (also a calculated field, showing positive values) Y axis and the chart just looks confusing.
Not sure what I am missing here, i have changed the 'Horizontal axis crosses' to 0. I have made the minimum and maximum bounds fixed, i have tried all the different charts. The only chart that visually represented what i wanted was the '100% Stacked column', however, i need to show actual figures rather than percentages.
Please see pics to see what my chart currently looks like and the 2nd pic for what the chart should look like.
This issue at first seemed really simple but I have been at this for hours and cannot make any progress. I have search a ton of articles, boards and all the solutions posed do not fix the issue i am facing, which is to place the secondary Y axis (which is a calculated field, showing only negative values) underneath the X axis. Instead, excel is placing the Y axis on the same level as the primary (also a calculated field, showing positive values) Y axis and the chart just looks confusing.
Not sure what I am missing here, i have changed the 'Horizontal axis crosses' to 0. I have made the minimum and maximum bounds fixed, i have tried all the different charts. The only chart that visually represented what i wanted was the '100% Stacked column', however, i need to show actual figures rather than percentages.
Please see pics to see what my chart currently looks like and the 2nd pic for what the chart should look like.