The layout editor supports a variety of chart types and styles to graphically present data in the layout.
Once inserted, you can edit the chart properties using the dynamic toolbars or the Properties pane. The Properties pane extends the options from the Chart tab and enables you to enter very specific custom settings for the following:
Chart Effect
Chart Legend
Chart Plot Area
Chart Title
Chart Label
Note:
The following Chart Label properties apply to Scatter and Bubble chart types only: Title Font, Title Horizontal Align, Title Text, and Title Visible.
Chart Values
Note:
Some font effects such as underline, italic, and bold might not render in PDF output.
Follow these steps to insert a chart.
The Chart tab helps you to apply a different chart type, filter the data, manage multiple filters.
The Chart tab enables you to perform the following:
Select a different Chart Type
Apply a different Chart Style
Enable 3-D effects
Filter the data that is displayed in the chart
Manage multiple filters
Convert the chart to a pivot table or switch the series and dimensions values
This section helps you to know how to apply and manage filters.
See About Filters for information on how to apply and manage filters.
Follow these steps to convert a chart to a pivot table.
To convert a chart to a pivot table:
The layout editor converts the label, series, and value elements of the chart into the appropriate rows, columns, and data elements of a pivot table.
By default, the chart displays a sum of the values of the chart measure. You can change the formula applied to a chart measure field by selecting an option from the Chart Measure Field tab.
To change the formula:
Charts can be sorted by fields.
To sort a field in the chart:
Create more useful charts by altering their appearance.
The following features enable you to apply additional formatting to your charts:
If you do not select a value for these format options above, the BI Publisher default system settings are applied.
When the x-axis of your line chart is a date field, BI Publisher applies a time series format based on the range of the data.
The following illustration shows the time series format options. You can customize the display of the time series in your chart, or turn it off.
To select time series date formatting options for a chart:
You can hide axis labels in reports for certain situations such as when you are working with small charts or visualizing data without values. This option is especially useful for creating reports that evaluate trends.
You can format decimal digits and numbers for each Y axis in a multiple Y-axis report.
You can set chart axis scaling as logarithmic or linear in reports.
To format axis scaling:
You can format pie slice charts to display percentages, total actual values, percentages, and labels.
To format pie slices: