DESIGN TAB IN EXCEL
Change Chart Type: This tool is used to change the chart type of selected chart.
Step 1: First select the chart, which style you want to change.
Step 2: Click on the "Design" menu.
Step 3: Click on "Change Chart Type" tool.
Step 4: Select the style.
Save As Template: This option is used to save a selected chart as a template.
Switch Row/Column: This option is used to interchange data "Axis field and "Legend field" in selected chart.
 |
| Chart Before Switch Row/Column |
 |
| Chart After Switch Row/Column |
Select Data: This tool is used to edit/delete "Chart data range", "Legend Entries (Series)" and "Horizontal (Category) Axis Labels"
Chart Layout: This tool is used to change the layout of selected chart.
In Microsoft Excel 2010, there are 10 types of different layouts are available.
Step 1: First select the chart, which layout you want to change.
Step 2: Click on the "Design" menu.
Step 3: Click on "Chart Layouts" tool.
Step 4: Select any chart layout.
Chart Styles: This is an already existing chart styles gallery, where you can select your desired chart style.
When you will click on this tool, it will show the following two options.
1. New sheet: This option is used to create a new chart sheet and move the selected chart on this chart sheet.
2. Object in: This option is used to move selected chart in an already selected worksheet.
0 Comments