Below are a few tips and tricks for working with charts in your models.
Showing invisible data labels
If the space in a data area (slice, bar, bubble) of a chart is too small, data labels (if activated in chart settings) will not be visible in the chart. In that case, resize the chart to make the labels visible.
Showing hidden bubbles in a bubble chart
If a bubble in a bubble chart is not visible, it may be hidden behind another bigger or same-sized bubble. To make a hidden bubble visible, highlight the category of this bubble in the chart legend by clicking the colored dot of the category. The hidden bubble will appear.
Changing the color of the chart borders
By default, the borders of a chart (if shown) are black. If you want to change the color of the borders of a chart, make sure that the Derive line color from fill color check box is cleared at the graphics options for diagrams and views. Next, follow these steps:
- Select the chart.
- On the Home tab, in the Markup group, click Line Color, and select a different color.
- Click to refresh the chart. The borders of the chart now change color.
Correct display of charts when using multiple model languages
If you have defined multiple languages, your model and the charts are also available in multiple languages, they will not automatically be displayed in the correct language when you switch model language. To display the correct language in the charts you have to refresh the chart after you switched model language. A chart can be refreshed by selecting the chart and then clicking .