Good morning
I have created a stacked column chart with 6 data points (Call them 1A, 1B, 2A, 2B, 3A, 3B), and the associated Legend.
Due to space constraints on where i want to put my chart, the legend will be in a format of 3 entries wide by 2 high. My data has 3 main areas, with 2 variants of each, so purely for presentation purposes i would like them to appear one on top of the other in the Legend Table. However in my Chart I want them to remain grouped together also (as in 1A, 1B, then 2A, 2B, and finally 3A, 3B) in order up the column. At present, with the legend scaled to be 2 high x 3 wide, the entries appear as follows:
1A 1B 2A
2B 3A 3B
My aim is to have them as follows:
1A 2A 3A
1B 2B 3B
I would like to change the order of the Legend so it reads easily, without actually changing the order of the chart itself as the stacked column is appearing just fine.
I have been unable to find any options in layout etc to move the legend entries around, and if I change the series order, it changes the chart itself? Flubbered !!!!!
Bookmarks