Hi Folks!This might be a really basic question but I can't work it out!I've been using the Pie Chart to show the sales by Price Type category and I love that it shows me the percentage of sales of each price type.Is there a way for the Y-axis of Bar Chart to be the percentage - so each bar is the percentage of sales per price type - rather than the actual numberI'm more interested in the ratio than the actual numbers but prefer the look of the Bar Chart in my dashboard
Cheers, Nicola
Yes, you can use a 100% stacked column chart.
Hi Ilana,Thanks for responding! For some reason when I'm trying to look at total tickets per price type or mode of sale, I cant select a stacked column chart at all.I was able to do it using the contribution function as Chris described below for separate bars :)