Dynamic Chart

Dynamic chart

A dynamic chart range is a data range that updates automatically when you change the data source.This dynamic range is then used as the source data in a chart. As the data changes, the dynamic range updates instantly which leads to an update in the chart.

follow the steps

1.   Click the Insert tab.

2.   In the Tables group, click Table.

3.   Excel will display the selected range, which you can change. If the table does not have headers, be sure to uncheck the My Table Has Headers option.

4.   Click OK and Excel will format the data range as a table.

     Any chart you build on the table will be dynamic. To illustrate, create a quick column chart as follows:

1.   Select the table.

2.   Click the Insert tab.

3.   In the Charts group, choose the first 2-D column chart in the Chart drop down.

     Now, update the chart by adding values for March and watch the chart update automatically.

Excel Anatomy - Create Your Own Ribbon

Create own ribbon

1. Right click on ribbon area and select “customize ribbon” option
2. Now, add a new tab (or group or both) – see below for illustration.
3. Add a few commands (or buttons) to your new ribbon 
4. Click ok and you have a sparkling new ribbon ready.

 

 

1. Use New Tab button to create a new ribbon tab.
2. Use New Group button to add a new group of commands to an existing or new ribbon.
3. Rename button helps you to change the name of an existing custom group or tab.
4. Once you add a group / tab, you have to select it to add items to that group / tab.
5. You can choose the type of commands you want to add to your ribbon tab / group. You can also add any macros as well (sweet!).
6. Now select the command you want to add to your group
7. Click on “Add” button to add the command to your ribbon tab / group.
8. You can use “Remove” button to remove any commands from custom tabs / groups.
9. Use the up / down arrow buttons to move your ribbon tab / group up or down. (For eg. you can move your custom tab to first, ie before home tab).

    A. You can export your ribbon customizations and re-use them in other computers (both ribbon and QAT settings will be exported).

        You can now add a group of commands (for eg. all alignment options) to Quick Access Toolbar to improve your productivity.