Hi,

I've run into a charting problem and have not been able to resolve it after much searching.

I have a stacked bar chart that refers to dynamically changing data. The issue is the category order is displayed backwards from the data in the excel sheet. For example:

Row1 - Series A, data point1, data point2, etc.
Row2 - Series B, data point1, data point2, etc.
Row3 - Series C, data point1, data point2, etc.

In the stacked bar chart the Series A will appear at the bottom next to the x-axis and also at the bottom of the ledgend, and Series C will be the top of the stacked bars.

The only answers I've found were to check "values in reverse order" and "maximum axis value"

But this does not work correctly. If I do this the bars will start at the top and "grow" downward. I need them to start at the bottom and grow upwards.

This seems like it should be easy, I just want the chart to match the data order.

Any help would be very much appreciated.

Thanks,