Stacked Bar Graph

[teel73]

I simply want to reverse the stacks in my bar chart. My chart shows total ERTs and total NON ERTs. Total ERTs is green and Non ERTs is blue. The blue bar is on top of the green bar. I want it to be in reverse (green bar on top of the blue bar.) See attached graph. It seems so simple but I cannot find the way to do it. Please help.

 

[Endre]

In the design view of your report, double click your graph. If you don't see a datasheet view of the data used in your graph, choose

View > DataSheet.

You should now see the data representing your graph. Select the entire columns for your graph and Cut/Paste/Delete as required.

Else, look at the graph properties, find the field "Row Source", and edit the data source (query/sql) in such a way as to sort your fields in descending order.

Kind Regards,
Endre