Special charts

This chapter will detail charts that are manipulated in a different manner from other charts.

Please click a desired topic to jump directly to the connected article:  

Waterfall chart
Circle chart
Line chart

 

 

Waterfall chart

Adding a waterfall chart is performed similar to other empower charts, however its data entry differs slightly. In an Excel® table an “X” is entered into the column that is to correspond to the sum of data of the previous data (in previous columns). In addition, it is also possible to set the direction of your waterfall chart. This way waterfall charts can also be set up in reverse. To change the direction of your chart, simply click on the Data button in the action bar, then click on either Left to right or Right to Left. For horizontal waterfall charts you have the options Bottom to top and Top to bottom.

You can also display multiple waterfalls after one another. To add a new waterfall within a chart, click Data in the Action Bar and select Edit Data. In the corresponding cell of the Excel® table enter the keyword “<new>”. The new waterfall chart will then begin at the next column while the sum starts at zero.

Circle chart

Insert a circle chart in the same manners as you would insert any other empower chart. What makes a circle chart different is that its user is unable to use chart features such as Lines; also, other settings such as Data Labels are not possible.

Click on Data Labels in the Action Bar in order to activate data labels of the chart. In Value label you can activate the value of the circle chart by toggling the Show Value slider. You can also set the number format as well as display the percentage of the value. You also have the possibility to set the decimal place of your percentage. Finally, you have the option to display the category names by activating Show Category Name.

In order to improve legibility of data labels of a background using the same color, you can insert transparent backgrounds for labels by activating Show data label background. In addition, you can reset the data labels to their original formatting by clicking Reset Data Labels. 

Line chart

Line charts can be inserted analogously to all other charts in empower.

Their difference lies in their ability to allow additional adjustments for lines and markers. With a single click on the line, you can set a line’s color, thickness, and type.

You can also smooth the lines of your charts. To do so, select the line and then click Properties in the action bar above the chart, then click Smooth Line.

In order to edit the markers of data points, simply select a marker. In the overly that opens you can now select from fill colors, type, as well as size of the element.

 

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.