Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Change order of Pie Graphs and Legend items
Summary
I created a Pie Graph view and would like to specify the order
Content
I created a pie graph view with multiple pie graphs and of course a legend. Is there a way to specify the order of the Pie Graphs and/or the Legend items?
I added a sequence field that will be the sort order field, but I cannot find a way to use that in any of the Pie Graph settings
It appears that both the Pie Graphs and Legend items are sorted by name; alphabetically
any help would be appreciated
Answers
-
Hi Shawn
From what I have experienced is that this is correct functionality. My workaround was to change those item names to be 1. Not Started, 2. In Progress, such that they show in the correct order. Hope that helps
0 -
You can add a column for sort order and add the 'sort order' column to the pie or bar graph. You can't hide the 'sort order' column in Graph. If you want to hide the 'sort-order' column in the graph, you'll need to use Pivot View. Select Graph only and on the Pivot column property for the 'sort order' column, select 'Hidden'. This will sort the column by your 'sort order' column on the Pivot graph while hiding the 'sort order' itself.
Ling
0 -
Hi Ling, do you know where I can find some instructions on how to add the sort column?
Thanks,
Raluca0 -
Adding a sort order column is the same as adding a column with custom formula. I'll post a document on how to add 'sort order' to table & graph.
Ling
0 -
This was very helpful, but I can only mark one as the best answer
0