Overview
In the chart data panel you will be prompted to select the series you wish to use in your chart and also edit the series style options.
Data Selection
Having selected your chart type, the data selection panel will be refreshed to display the appropriate options for the chart time.
- Select the data you wish to use for your report as prompted by the available options - see the table below for more detail on the definition of these.
Note: if you have more than 1 dimension in your report data Yellowfin will automatically aggregate the data in the report to accurately chart the label dimension selected. This is a very powerful way for you to visualise and gain insight into your data. - Once you have selected the fields you wish to use click the refresh link to display the selected series in the Series Settings edit panel.
The following table displays the data selection options for the various types of charts that you select.
Animation
Charts that are built with a date or datetime field available will have an Animation option displayed in the Chart Data area.
Animation uses a date field to slice up the chart into frames, much like a section slices up a table into sub tables. Simply select the date field, such as Year, as the animation field and Yellowfin will create a frame per year value. When you return to the report preview page you will be able to play the animation or step through using the navigation buttons.
It is also recommended that you change the Chart Title option to display the Animation Field, rather than the Report Name, in order to provide the report writer with a label for each frame.
Note: The animation option will only be available if a date field has been used in the report. It's also important to remember to use a date field that won't create too many frames, as animation is meant for high level data, like year rather than day.
Series Settings
Once you have select the series you wish to apply the selected series will be displayed in the series settings panel.
The series setting panel lets you set the style and colours of selected series. Although defaults are applied you can change these by managing the individual series.
The choices available for your series settings will vary based on the chart type selected and whether Conditional Formatting has been applied to your data.
Series Colour Settings
Option |
Description |
---|---|
Style |
When setting the colour style of the series you can choose default or either set solid colour or gradient colour options. |
Direction |
If you have selected gradient you can set the direction of the gradient to be applied. |
Colour |
If not selecting default you can set the colour(s) to be applied to the series. |
Border Colour |
For bar style series you can select the series border colour. |
Width |
For bar style series you can select the series border thickness. |
Line Thickness |
For line and Area charts you can set the weight of the line. The Area line is the line at the top of the area chart. |
Opacity |
Opacity is only available for area charts. Use this to reduce the opacity of the area and highlight the area line which will remain solid. |
Series Conditional Formatting
If a series has conditional formatting applied to it you will have the option for appropriate charts to display these on the chart in a variety of styles.
Option |
Description |
---|---|
Display |
If you wish to display the conditional formats for the column select 'Yes'. |
Style |
The style setting lets you choose how you want to display it. Choices include: |
Position |
Select how you wish the conditional format to be displayed - in front of or behind your chart data. |