We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Why are stacked bar charts backwards from the data? [closed]

asked 2017-08-05 03:53:31 +0200

endolith gravatar image

updated 2017-08-05 03:54:05 +0200

If I use the data

    a   b   c   d
A   2   3   3   2
B   2   2   2   3
C   3   3   3   2
D   2   2   2   3

and make a stacked bar chart, the categories are backwards (D C B A), the bar colors are correct (colored a b c d), but the legend is backwards (d c b a).

image description

How do I rearrange these into a sane order? Is this a bug that can be fixed?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-10-12 13:54:42.865473

1 Answer

Sort by » oldest newest most voted

answered 2017-08-05 11:50:18 +0200

m.a.riosv gravatar image

updated 2017-08-05 23:15:41 +0200

Double click on the chart to edit.

Right-click and select Data Ranges
Select Data Series tab.
With the arrows move series up/down.

Edited 21070805


edit flag offensive delete link more


No, that just reverses the data series, so now the legend is in the correct order but the bars are backwards and the categories are still backwards.

endolith gravatar imageendolith ( 2017-08-05 21:45:29 +0200 )edit

Creating from scratch looks fine for me, See the test file in the answer.

m.a.riosv gravatar imagem.a.riosv ( 2017-08-05 23:17:37 +0200 )edit

in your test file, the categories are backwards, and the bars aren't stacked.

endolith gravatar imageendolith ( 2017-08-06 14:34:12 +0200 )edit

Question Tools

1 follower


Asked: 2017-08-05 03:53:31 +0200

Seen: 730 times

Last updated: Aug 05 '17