|
Available from Version: - |
|
Operating System: Windows |
|
empower® Add-in: Charts |
|
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 1, “Open Full Excel Window”).
|
Via the group Clipboard, you can cut and copy values from cells in the Excel table (Figure 2, “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 3, “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 4, “Button ”). |
|
|
To insert a new row, click on the button (Figure 5, “Button ”). The row will be added above the currently selected row. |
|
|
To insert a new column, click on the button (Figure 6, “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 7, “Button ”). |
|
|
To delete a column, click on the button (Figure 8, “Button ”). |
|
|
To open further formatting options, click on the button (Figure 9, “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 10, “Button ”). |
|
Note
To open the formatting options, you can also use the keyboard shortcut .
|
To reverse the row order, click on the button (Figure 11, “Button ”). |
|
|
To reverse the column order, click on the button (Figure 12, “Button ”). |
|
|
To change rows to columns and vice-versa, click on the button (Figure 13, “Button ”). Row 1 will then become column A. |
|
|
To sort your rows according to their sum, click on the button (Figure 14, “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 15, “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 16, “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 17, “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.