Chart with Cycle expression - change axis limit and number
Hello Everyone,
I have a chart that is a stacked barchart. There is a cycle expression group:
1. straight count
2. straight count as a percentage of the dimension (so I get 100% stacked bar charts)
The cycling between them works fine. What I want though, is when I am looking at the 100% expression I want the y axis to max at 1 and the number to be shown in percentage. I want the axis to be raw values for the straight count with no limit.
to achive this you need to set your Axes attributes twice , once for each of the expressions you are cycling. To do this toggle to the expression you wish to modify (the straight count as a percentage). Open your chart properties, go to the axes tab make sure the Scale etc. is how you want it.
When you are using a cyclic group the Expression axes box on the axes tab only shows the current used expression. Hence this workaround.
The number formatting shoudl simply be achieved using the chart property -> number tab.
to achive this you need to set your Axes attributes twice , once for each of the expressions you are cycling. To do this toggle to the expression you wish to modify (the straight count as a percentage). Open your chart properties, go to the axes tab make sure the Scale etc. is how you want it.
When you are using a cyclic group the Expression axes box on the axes tab only shows the current used expression. Hence this workaround.
The number formatting shoudl simply be achieved using the chart property -> number tab.
