Bar Chart: Show percentage difference between highest value bar and all other bars
I'd like to show the difference in percentage between the highest value bar in my bar chart and the other bars in the same chart. Is there any way I can do this? Details about the chart below:
- Y Axis = Avg Price by State
- X Axis = State (I have four states in total)
I've thought about doing this two ways and I've been successful at neither.
- Ordering the bar chart by value and displaying the deltas between the top value state (KS) and the others (TN,LA, and NY) in some sort of stacked bar format. See image 1 for a mockup of what this might look like.
- Adding error bars to by bar chart that extend to the stop value. I've been able to achieve this in Spotfire, but only through hardcoding the top value into the error bar expression. I also have not been able to add labels to the error bars. Image 2 will show you what I have in Spotfire thus far for this method.
If anyone could assist me in showing the difference in percentage between the highest value bar in my bar chart and the other bars in the same chart using either of the methods above or an entirely new method I'd greatly appreciate it. Happy to provide more information if needed.
May be this can be achieved by using R-scripting. However, can you share some sample data?
Also in your mockup bar chart what column you are using in your colors properties?