Thank you for your replies.
I am having trouble with getting the same output.
In addition, here is how my table looks like:
LOAD * INLINE [
Year, Region, Amt, Pct
2012, WE, 104, 25.3
2012, EE, 81, 19.3
2016, WE, 250, 59.8
2016, EE, 223, 52.7
I have noticed in your document that second expression is as "Line" marked. In my case that option is not available (I can´t click on it because it is faded.). How can I make it a line expression?
One more question - how can I add "%" sign to expression?
according to my knowledge it is possible in this way...
per cum values.qvw 150.2 K
If you were referring to the previously sent QVW, could you please generate the same chart by talking the inline table I sent?
I was having troubles generating bars with different colors.
I still have problems with setting percentage inside the middle of the bar, and adding "%" sign to the amount of percentage.
I would like to know also if it is possible to display every value in the stacked bar.
For example, if in bar chart I have three different values stacked on top of one another to form one bar in the bar chart, is it possible to display in the middle of every part the corresponding value? If yes, please how?
Using a bar chart you cannot replicate the same format you have in your image. You can place values only on top or inside the bars, however if you have more than one expression, all values will be on top or inside, you cannot choose different places for each plotted expression.
What you can do is
- Place one expresion values in the X axis
- Do not plot the second expression and place its values on top or inside the bars, Or show the values only as a popup.
Review the attached.
Also, if you create a stacked chart, you cannot force all values to be shown since this depends on whether each part is big enough so that the text is shown. I haven't found a workaround to solve this.
multiple values on bars.qvw 150.8 K