how to reverse pie chart widths?

[vj135]

hi,

I have a pie chart with the biggest slice assigned to the highest % number.

Is it possible to reverse it -- with the smallest % number assigned to the largest slice?

Also if the above is NOT possible then is it possible to change the sizes of the individual pie slices?

the whole idea behind this is to make the smallest pie sizes more significant.

for example the white population in the company is 80% with the rest allocated to the various minorities.

In this case if the FOCUS is on minorities then reversing the standard pie chart to what i have requested above makes sense.

any help is appreciated

thanks
vj

 

[lbass]

I don't think that does make sense, but if you want to highlight the non-white populations, then why not use specified order and add all but the white population to the specified order list and then on the "others" tab, choose "discard all others". Then the pie chart will show only the non-white populations. Or better yet, exclude the white population in the record selection formula.

-LB

 

[vj135]

i dont see "specified order" option in the chart expert or "chart options"

where is it?

thanks
vj

 

[vj135]

ok i found it

will try and get back to u

thanks

 

[vj135]

if i exclude the white population group then the others add upto 100% -- which is not right either.

are there some other graphs like histogram etc which will depict what i want to?

thanks