BI Analytics Chart Option

Each type of chart available in BI Analytics contains options that allow you to customize the way it displays its data. Certain options are available for specific chart types and certain options are available in all charts. For example, the color modification options are available for all chart types.

For general information on BI Analytics, see BI Analytics.
For information on filtering data in BI Analytics, see Filter BI Data.
For information on creating dynamic presentations of your BI data, see BI Analytics Presentations.

To modify a chart's color display

1. Hover over the chart and click .
2. Select a color option.

• (Optional) If you select to vary color based on data:

  • Select a color scheme. You can choose between a color scheme containing 12 colors or 100 colors.
  Note:

  People with color vision deficiencycan differentiate between all of the colors in the 12-color option, but not all of the colors in the 100-color option.

  • If the option to display persistent colors in the chart is available, select the Persistent colors check box.
  • Use the show legend slider to determine if the chart includes a legend indicating what each color item corresponds to.

• (Optional) To cancel your selections, click Discard.
  

Pie chart

Chart Position

You can rotate a pie chart to better read certain labels.

• To rotate a chart, hover over it and use the the Scroll wheel on your mouse.

Another way to arrange the position of the chart is to select how the pie chart is sorted.
To sort a pie chart by one of its relevant fields

1. Hover over the chart and click .
2. In the Sorting menu select the field you want to sort by.
3. Select to sort the chart in Ascending or Descending order.
   (Optional) To cancel your selections, click Discard.

Modify chart format

You can select to display your chart in Pie or Donut format.

To modify the chart's format

1. Hover over the chart and click .
2. In the Presentation menu select Pie or Donut.
   (Optional) To cancel your selections, click Discard.

Modify chart labels

You can select if you want the sections of your chart labeled and how to label them.

To modify the chart's labels

1. Hover over the chart and click .
2. In the Presentation menu select one of the following Label options:
   • None - Do not label chart sections.
   • Share - Label each section with the percent of the chart it represents
   • Values - Label each section with the total number of items it represents.
     (Optional) To cancel your selections, click Discard.
     
     At any point you can return to Sheet view, by clicking .

Modify chart dimensions

Certain charts allow you to modify the dimensions that the chart displays

To modify the chart's dimensions

1. Hover over the chart and click .
2. In the Dimensions menu select the dimension you want the chart to display.
   (Optional) To cancel your selections, click Discard.

Bar chart

If a bar chart is too big to display entirely in its allotted space on the sheet, you can click and drag within the chart to scroll vertically or horizontally.

Sort

You can determine the order that the bars appear by selecting the sort method for the chart.

1. Hover over the chart and click .
2. In the Sorting menu select the field you want to sort by.
3. Select to sort the chart in Ascending or Descending order.
   (Optional) To cancel your selections, click Discard.
   

Modify chart format

You can select to display your chart in with vertical or horizontal bars.

To modify the chart's format

1. Hover over the chart and click .
2. In the Presentation menu select Vertical or Horizontal.

(Optional) To cancel your selections, click Discard.

Add or remove chart labels

You can select if you want to label the bars in your chart.

To add or remove the chart's labels

1. Hover over the chart and click .
2. In the Presentation menu click the Value labels slider to enable or disable chart labels for each bar.
   (Optional) To cancel your selections, click Discard.
   

Open SR Overview chart

The Open SR Overview chart, located in the Currently Active SRs Overview sheet, is unique in that it allows you to select what field you want to measure in your open SRs.

To select a field

1. Click the drop-down menu beneath the chart.
2. Select an SR field.
   

Line chart

If a line chart is too big to display entirely in its allotted space on the sheet, you can click and drag within the chart to scroll vertically or horizontally.

Sort

You can determine the order that the lines appear by selecting the sort method for the chart.

1. Hover over the chart and click .
2. In the Sorting menu select the field you want to sort by.
3. Select to sort the chart in Ascending or Descending order.
   (Optional) To cancel your selections, click Discard .
   

Modify chart format

You can select to display your chart data with lines or stacked areas.

To modify the chart's format

1. Hover over the chart and click .
2. In the Presentation menu select Line or Area.
   (Optional) Click the Logarithmic scale slider to enable or disable Logarithmic scale in the chart's display.
   (Optional) To cancel your selections, click Discard.
   

Add or remove chart labels

You can select if you want to label the points in your chart.

To add or remove the chart's labels

1. Hover over the chart and click .
2. In the Presentation menu click the Value labels slider to enable or disable chart labels for each point in your chart's lines or areas.
   (Optional) To cancel your selections, click Discard.

Scatter plot chart

When you are viewing a scatter plot chart in the sheet, you can hover over the chart and use your mouse's scroll wheel to zoom in and out on the chart. Click and drag the chart view the areas that you want. When you are viewing the chart in Full Screen mode, you can also use the the Zoom in and Zoom out buttons and the navigation arrows if Navigation is enabled.

To enable/disable the Navigation buttons

1. In Full Screen mode, click .
2. Click the Navigation slider.
   (Optional) To cancel your selections, click Discard.

Add or remove chart labels

You can select if you want to label the dots in your chart.

To add or remove the chart's dots

1. Hover over the chart and click .
2. In the Presentation menu select one of the following Label options:
   • Auto - Label some of the dots, based on the available space around the dot.
   • All - Label all of the dots regardless of the space around the dot.
   • None - label none oft he dots in the chart.

(Optional) To cancel your selections, click Discard.

Modify size of dots in the chart

The scatter plot chart displays data in the form of dots on the chart. You can set the precise size of the dots in the chart.

To modify the chart's dot size

1. Hover over the chart and click .
2. In the Presentation menu click and drag the Bubble size slider until the dots reach the desired size.
   (Optional) To cancel your selections, click Discard.