When creating a Stacked Bar Chart with the following Figures -
-- 5 distinct Car manufactures
-- Each manufacturer has between 2 - 6 models
-- Sales figures for each each of the models of the Car Manufacturers
The stacked Bar chart has stacks of Car Manufacturers, each stack having the models of the cars they create on the X-Axis and Sales on the Y-axis.
Once the chart is displayed, the sorting order is completely random when trying to sort the graph. It is requested to sort the stacked charts in the ascending order of Sales Revenue summed up for all the models for each manufacturer.
Is this possible.