Pie Chart order of Data 1

[herkiefan]

Hi experts,

My new boss maybe the most annoying person I've ever worked with. He nit-picks about the stupidest (IMHO) things.

Is it possible to change the order in which a pie chart reports information, without changing the order of the source data?

As an Example:

A 20%
B 40%
C 10%
D 30%

The Pie Chart begins with A and then moves counter-clockwise in the order of the data. Is it possible to change the order of the chart where the highest % is first and then decreases as it moves counter-clockwise without changing the order of the underlying data?

I've already offered the solution of setting up a separate "chart data" table that we could sort by value, however, my boss in his infinite wisdom does not want to have to sort anything.

Serenity Now!!!!



“Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.”-Albert Einstein

 

[xlbo]

AFAIK, there is no option to change the display order - it will be ordered based on the order in the source data. If the boss wants it in a different order he will have to sort!

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question