Hi, I have a stacked bar chart with sales divided by customer and I want the bar chart to be sorted by the largest customer on bottom from an accumulated stand point. Months are on the x-axis, so for example customer A has the greatest proportion of revenues up to April, but in April Customer B has the greatest revenues for only that month. However, customer A should be on the bottom because it has the greatest accumulated revenues.
How do I go about sorting the bar charts by accumulation?
Thanks in advance,