- Advanced Excel Tutorial
- Advanced Excel - Home
- Excel New Features
- Excel - Chart Recommendations
- Advanced Excel - Format Charts
- Advanced Excel - Chart Design
- Advanced Excel - Richer Data Labels
- Advanced Excel - Leader Lines
- Advanced Excel - New Functions
- Fundamental Data Analysis
- Excel - Instant Data Analysis
- Excel - Sorting Data by Color
- Advanced Excel - Slicers
- Advanced Excel - Flash Fill
- Powerful Data Analysis
- Excel - PivotTable Recommendations
- Powerful Data Analysis – 1
- Advanced Excel - Data Model
- Advanced Excel - Power Pivot
- Excel - External Data Connection
- Advanced Excel - Pivot Table Tools
- Powerful Data Analysis – 2
- Advanced Excel - Power View
- Advanced Excel - Visualizations
- Advanced Excel - Pie Charts
- Advanced Excel - Additional Features
- Advanced Excel - Power View Services
- Advanced Excel - Format Reports
- Advanced Excel - Handling Integers
- Other Features
- Advanced Excel - Templates
- Advanced Excel - Inquire
- Advanced Excel - Workbook Analysis
- Advanced Excel - Manage Passwords
- Advanced Excel - File Formats
- Excel - Discontinued Features
- Advanced Excel Useful Resources
- Advanced Excel - Quick Guide
- Advanced Excel - Useful Resources
- Advanced Excel - Discussion
Advanced Excel - Chart Design
Ribbon of Chart Tools
When you click on your Chart, the CHART TOOLS tab, comprising of the DESIGN and FORMAT tabs is introduced on the ribbon.
Step 1 − Click on the Chart. CHART TOOLS with the DESIGN and FORMAT tabs will be displayed on the ribbon.
Let us understand the functions of the DESIGN tab.
Step 1 − Click on the chart.
Step 2 − Click on the DESIGN tab. The Ribbon now displays all the options of Chart Design.
The first button on the ribbon is the Add Chart Element, which is the same as the Chart Elements, given at the upper right corner of the Charts as shown below.
Quick Layout
You can use Quick Layout to change the overall layout of the Chart quickly by choosing one of the predefined layout options.
Step 1 − Click on Quick Layout. Different possible layouts will be displayed.
Step 2 − As you move on the layout options, the chart layout changes to that particular option. A preview of how your chart will look is shown.
Step 3 − Click on the layout you like. The chart will be displayed with the chosen layout.
Change Colors
The Change Colors option is the same as in CHART ELEMENTS → Change Styles → COLOR.
Chart Styles
The Chart Styles option is the same as in CHART ELEMENTS → Change Styles → STYLE.
Switch Row / Column
You can use the Switch Row / Column button on the ribbon to change the display of data from X-axis to Y-axis and vice versa. Follow the steps given below to understand this.
Step 1 − Click on Switch Row / Column. You can see that the data will be swapped between X-Axis and Y-Axis.
Select Data
You can change the Data Range included in the chart using this command.
Step 1 − Click on Select Data. The Select Data Source window appears as shown in the image given below.
Step 2 − Select the Chart Data Range.
The window also has the options to edit the Legend Entries (Series) and Categories. This is the same as Chart Elements → Chart Filters → VALUES.
Change Chart Type
You can change to a different Chart Type using this option.
Step 1 − Click on the Change Chart Type window. The Change Chart Type window appears.
Step 2 − Select the Chart Type you want. The Chart will be displayed with the type chosen.
Move Chart
You can move the Chart to another Worksheet in the Workbook using this option.
Click on Move Chart. The Move Chart window appears.
