|
Available from Version: - |
|
Operating System: Windows |
|
empower® Add-in: Chart Creation |
|
To open the mini Excel, perform a double-click on the chart. The mini Excel opens. |
|
|
All mini Excels have an action bar which can be used to edit the table. This action bar only differs slightly depending on the chart type. |
|
|
In addition to the available actions, the mini Excel provides an undo and redo action in the upper left corner of the mini Excel. |
Note
Most options in the mini Excel's action bar are Office built-in options.
For further information regarding these options, see Microsoft Support.
Note
Actions executed via the groups Insert, Delete and Table cannot be undone.
Note
You can always open the mini Excel in a full Excel window. To do so, click on the symbol in the upper left corner of the mini Excel (Figure 517, “Open Full Excel Window”).
|
Via the group Clipboard, you can cut and copy values from cells in the Excel table (Figure 518, “Buttons and ”). |
|
|
If you cut or copy a value, the value is marked as cut-out or copied. |
|
|
To paste the value, you can either use the button to fill in the value in the source format or to fill in the value in the destination format (Figure 519, “Pasting Options”). |
|
|
In addition, you can use the button to copy the format of the selected cells and paste it to the cells you select next (Figure 520, “Button ”). |
|
|
To insert a new row, click on the button (Figure 521, “Button ”). The row will be added above the currently selected row. |
|
|
To insert a new column, click on the button (Figure 522, “Button ”). The column will be inserted before the currently selected column. |
|
Note
If there is a running copying or cutting action, it is not possible to insert rows or columns.
|
To delete a row, click on the button (Figure 523, “Button ”). |
|
|
To delete a column, click on the button (Figure 524, “Button ”). |
|
|
To open further formatting options, click on the button (Figure 525, “Button ”). A dialog box opens. Here, you are provided with the Office built-in formatting options. |
|
|
To remove all formatting from the selected cells, click on the button (Figure 526, “Button ”). |
|
Note
To open the formatting options, you can also use the keyboard shortcut .
|
To reverse the row order, click on the button (Figure 527, “Button ”). |
|
|
To reverse the column order, click on the button (Figure 528, “Button ”). |
|
|
To change rows to columns and vice-versa, click on the button (Figure 529, “Button ”). Row 1 will then become column A. |
|
|
To sort your rows according to their sum, click on the button (Figure 530, “Button ”). Clicking the button a second time will perform the opposite action. |
|
|
To sort your columns according to their sum, click on the button (Figure 531, “Button ”). Clicking the button a second time will perform the opposite action. |
|
Note
Where possible formulas contained in the table are preserved. The transposing and sorting options will convert any formulas contained in the table to values.
Note
The group Table is only available for data charts.
|
A Gantt chart only requires certain columns. If there are superfluous columns in your Excel table, remove them all at once by using the button (Figure 532, “Button ”). |
|
Note
The button is only available for Gantt charts.
|
If you need help when editing the mini Excel, click on the button in the mini Excel's action bar (Figure 533, “Button ”). A dialog box opens. Here, you will be provided with further instructions. |
|
Note
The button is only available for Gantt charts, Mekko charts and waterfall charts.
Comments
0 comments
Article is closed for comments.