Do you want to have a fixed axis range of both negative axis and positive axis shown below?
Please check my sample workbook attached and let me know if it works for you
fixed axis.twbx 4.9 KB
Hi Zhouyi, this seems to be a good idea, but it is very similar to my actual situation. Also in your workbook, for example, the negative axis could be between -5 and 0, because the minimum value is -4 for negative measure.
Is it possible to have two different ranges?
Concept: Use Reference Lines to create dynamic axises.
1. Using your largest axis (y in your case) create Ref Line: WINDOW_MAX(SUM([y]))
2. Put this calc on the Detail shelf on the All tab
3. Ctrl-Drag this to the Detail shelf on the All tab (you now have 2 Ref Line pills on the Detail shelf)
4. Double-click one of them and put a negative sign in front of the calc: -[Ref Line]
5. Right-click the positive axis and select Add Reference Line
6. In the dialog box change it from Per Pane to entire table
7. Change it from SUM([y]) to Ref Line and select Maximum as the aggregation, then close the dialog box
8. Right-click on the negative axis, click Add Reference Line
9. Change to Entire Table
10. Change from SUM([x]) to -[Ref Line] and select Max (or Min) as the aggregation then close dialog box
You should now have something that looks like this:
Edit the reference lines to get rid of the lines. Also you can go to each of the individual shelves and remove the Ref Line calc that is not being used.