Labels on graphs with different data than represented by the bars
I made a bar stacked bar chart, with data on the on time arrival of trucks. I'm showing what percentage of trucks arrive on time, what percentage within 30 minuts of their booked time, which within 60 minutes, etc. So I made the following expressions in my chart:
Re: Labels on graphs with different data than represented by the bars
Thank you for your help. I see that if I use this formula, when I press the charts, it switches between the two datasets. So it does not exactly do what I hoped for, but it is an alternative if it is not possible to put different datalabels on the chart.
However, if I make this switch, my Y-axis still shows the data as a percentage (so in stead of 700 loads, it shows 700%). How do I let the chart itself change too?