Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
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.
Any ideas how to achieve this?
Thanks
Gareth
 
					
				
		
 pat_agen
		
			pat_agen
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		hi Gareth,
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.
hope this helps
 
					
				
		
 pat_agen
		
			pat_agen
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		hi Gareth,
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.
hope this helps
 
					
				
		
Thanks mate, perfect!
