Showing the data in Clockwise in Pie chart

building reports webintelligence
1

Hi All,
I would like to show the data in the clock wise direction in pie chart.Suppose if I have the data as High,Medium,Low and have to show in clock wise means the High shoud start at 12o’clock point like on the clock.
Is there any sorting order for pie charts in Webi.I am using XI 3.1 SP3.

Appreciate any help.
Many Thanks
Dheepa

Dheepa (BOB member since 2010-07-23)

2

In “Structure mode” '(click on “View structure”) you’ll be able to put a sort on the fields in the graph, including custom sorts.

But I can’t see a way to set the “start” of the pie at 12 o’clock though…

KFonMurphi :fr: (BOB member since 2007-10-16)

3

I am also facing same kind of issue in the pie chart i want to display the sorted order in clock wise, but it is showing in Anti clock wise.

Dheepa: Did you find the solution for this?

lovebo :india: (BOB member since 2010-10-06)

4

Any ideas/suggestions please?.Even Im facing same issue

Jj John (BOB member since 2011-11-12)

5

Hi,

i am not sure what data your report contains…but the below might help you…

Select the entire Pie block --> Rt click --> Turn To --> Select Vertical Table.

Now sort the dimension column in Descending order.

Then again select the entire table --> Rt Click --> Turn To --> Pie.

Hope you can see the data in Pie chart in clock wise direction.

chaitanya_b (BOB member since 2011-11-21)

6

Thanks chaitanya…logic works for excel.But would like to have same in both excel & webi report.any idea?

Jj John (BOB member since 2011-11-12)

7

Hi,

I am talking about WebI only… I tried in WebI and it worked for me…i never did it in excel… :o

chaitanya_b (BOB member since 2011-11-21)