Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Good Afternoon -
I have a simple bar chart with no dimensions and multiple expressions (as my data is in different columns) and I'm trying to figure out how to not only show the actual value but include an industry benchmark. Much appreciate any help!!!!
This is what I have

This what I want

 
					
				
		
 chaper
		
			chaper
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Connect the standard values(as Excel or Inline) to data through dimension or date .Then you can easily plot the standard values.If you can't connect to data other option is add calculated expression ex:if (Dimesion='SBE','6.5%') and display it as text as popup.Downside is you won't see number in chart until you hover over each bar.
 
					
				
		
 chaper
		
			chaper
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Post a sample app or data
 
					
				
		
Here you go....I'm looking to have Standard_A displayed within the A bar, and so on.
 
					
				
		
 chaper
		
			chaper
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I used Inline table
 
					
				
		
How would you do in without Inline as my data in the graph is made up of 15 different expressions
 
					
				
		
 chaper
		
			chaper
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Inline is similar to your excel file I added Standards to respective Fields(A,B,C,D) instead of variables.If you post real sample application with 15 expressions then I can look into.
 
					
				
		
Thx Chai - appreciate the time and help. I've found an alternative to displaying the benchmarks but will try to post something as soon as I can as I know this will come up again for me.
 
					
				
		
 chaper
		
			chaper
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I got the wrong graph in app.The bar chart will look like this
 kkkumar82
		
			kkkumar82
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi ,
As suggested use combo chart and make the line expression as invisible in the expressions tab then you won't get the line.
Hope it helps .
KK
 
					
				
		
Thanks KK - how ever a combo chart is not going to work as I do not have any Dimensions and 15 expressions representing 15 different results.
