Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pie Chart order of Data 1

Status
Not open for further replies.

herkiefan

Technical User
Oct 13, 2006
97
US
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top