Excel Stacked Columns Graphs and reordering in descending order for each stacked column

Question

Hi All, need help with Excel Stacked Columns Graphs - There are multiple stacked columns in excel say 3 (Year 1, Year 2 and Year 3) and in each of the columns are more than 1 data series (apples, oranges, pears), I need to reorder the data series in each stacked column from highest number to lowest number (descending order) - how can this be done? reordering the data series in "select data series" format will only move the same data series across all the stacked columns in the same order but this is not what i want. each year column will have different ordering. Thank you, C

Answer 1

Correction to my earlier email - Sorry Snow Lu, i was wrong using about using "format the axis" and function "values in reverse order" because it didn't solve my problem. you are right it cannot be done by the existing excel auto functions. Thanks anyway.