Bar Graph Sorting

calvert_schaefer · 2024-03-04T23:00:45+00:00

There was an error rendering this rich post.

I am trying to create a stacked bar chart and sort by total sales. I have a field in the legend so I can see the composition of total sales. For some reason it is not sorting the chart descending by total sales like expected. What am i missing here ?

setup: as you can see I have sales dollars descending in the sorting yet for some reason it is not producing the expected format. Redacted y axis for privacy

Find more posts tagged with

Visualization

Accepted answers

MarkSnodgrass

In the Chart Properties under General, set Sort On Totals to descending. This will make your chart group by the overall total and not the individual items.

All comments

ArborRose

Is it possible your series is affecting the sort?

calvert_schaefer

@ArborRose I believe in your example you are sorting the Y axis alphabetically. I am trying to sort the Y axis based on Sales Dollars.

ArborRose

I think your "FORECA…" series needs to be in the sort

In my sample if I move value 2 to the front (blue), I get this sort.

calvert_schaefer

Unfortunately that gives me the same result. Here is an example of my underlying dataset. The value I'm using is a beast mode = sum(`value`). Here is an example of the dataset

sort issue.xlsx

ArborRose

I think you need to create a calculated field. Something like Total Sales, where the formula is SUM(VALUE). Put that in the sort.

calvert_schaefer

@ArborRose the value I'm using is a beast mode = sum(`value`). Additionally my dataset does not have 2 value columns, just 1 with a column delineating the forecasted account . Here is a sample. I have attached above as well.

ArborRose

Having the sample dataset helps. I understand what you are trying to do. But I'm also not seeing it sort as I think it should. I'll look further when I have a chance.

MarkSnodgrass

In the Chart Properties under General, set Sort On Totals to descending. This will make your chart group by the overall total and not the individual items.

ArborRose

Mark is absolutely correct. I forgot that was there.