-2

I have the table in Excel: enter image description here

I have generated 100% stacked column chart for this data. It looks like this: enter image description here

But it's not arranged. I want the stacked chart to be arranged in ascending order. Parameter is accuracy rate (%). So I want green columns (accuracy rate) to be arranged in ascending order from left to right. Red columns is error rate. In my table data is arranged by accuracy.

For the chart Excel generated some table. I tried to sort it from smallest to largest (by accuracy rate paramemter), but it didn't work: enter image description here

How can I do it in Excel?

Excel file: 4.14 (SO).xlsx

Erba Aitbayev
  • 4,167
  • 12
  • 46
  • 81

1 Answers1

1

https://drive.google.com/file/d/0B7hY4V8Ao1O9SFRmYXg1UTZjOVU/view?usp=docslist_api

Please follow the link.

I have used data sorting + pivot sorting, both are working fine.

Sonu Kumar
  • 108
  • 6