When you are creating a view, you define the view type and display style. This is done only once, during the view creation process. Once the view is created, you cannot edit these two settings.
To define the view type and display style:
Table
Pivot Table (the default)
Line Graph
Bar Graph
Column Graph
Area Graph
Pie Chart
Scatter Chart
Stacked Column Graph
The selection that you make affects the options available in Display Style along with the fields in the layout area.
Note:
You cannot change this selection when editing the view either in Oracle Smart View for Office or Oracle Business Intelligence Answers.
Display style determines how the view is inserted into Excel.
You cannot change this selection when editing the view either in Smart View or BI Answers.
Table 19-1 View Type Selected and the Display Style Available
Excel Table
Pivot Table (default)
Excel Pivot Table (default)
Pivot Table
Line Chart
Bar Chart
Column Chart
Area Chart
Stacked Column Chart
Excel Chart
Chart Image
Scripting on this page enhances content navigation, but does not change the content in any way.