Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I am trying to show values on data points on a combo chart. I can do it on the "bar part" of the chart, but cannot do it on the "line part". You have the chart uploaded, along with the data. What I need is the numbers that are already there on the bar chart, plus the Scheduled Loads on the line chart, both in the same time.
PS: I have the free version, so I cannot open qvw created by others, therefore, if you can help me, try to explain me what you did or take some screenshots. Thanks!
Go to Expressions tab select the line expression and then check "Value on Data Point". It will help you.
I know this. It's not what I want. It will show me 100% because of how it's calculated. I want to show the integers. Please open the qvw and familiarize yourself with the data and the chart (it's really simple), maybe you could come up with a solution.
Thanks
Hi Adrian,
Not quite what you're looking for, but if you change your expression to provide the values you could include both values, for example:
sum([Actual Loads]) & ' out of ' & sum([Scheduled Loads])
would provide both your figures in the same place. Adding another expression is going to put your values in the same place as the other expression.
hi,
hope this will help you
check the Value on Data Point --- it will show the values on data point make sure you selected You Expression on which you want to show values.
In this example your using number format with Percentage
that's why it show the values in 100%.
I've done this as well. I wanted to know if it's a way to either to "reformat" the chart or to use the same formatting but display, instead of 100%, the actual number?
Go to Number Tab and Uncheck the Show in percentage(%). it will show the actual no.