![Excel Charts Tutorial](/excel_charts/images/excel-charts-mini-logo.jpg)
- Excel Charts Tutorial
- Excel Charts - Home
- Excel Charts - Introduction
- Excel Charts - Creating Charts
- Excel Charts - Types
- Excel Charts - Column Chart
- Excel Charts - Line Chart
- Excel Charts - Pie Chart
- Excel Charts - Doughnut Chart
- Excel Charts - Bar Chart
- Excel Charts - Area Chart
- Excel Charts - Scatter (X Y) Chart
- Excel Charts - Bubble Chart
- Excel Charts - Stock Chart
- Excel Charts - Surface Chart
- Excel Charts - Radar Chart
- Excel Charts - Combo Chart
- Excel Charts - Chart Elements
- Excel Charts - Chart Styles
- Excel Charts - Chart Filters
- Excel Charts - Fine Tuning
- Excel Charts - Design Tools
- Excel Charts - Quick Formatting
- Excel Charts - Aesthetic Data Labels
- Excel Charts - Format Tools
- Excel Charts - Sparklines
- Excel Charts - PivotCharts
- Excel Charts Useful Resources
- Excel Charts - Quick Guide
- Excel Charts - Useful Resources
- Excel Charts - Discussion
Excel Charts - Design Tools
Chart tools comprise of two tabs DESIGN and FORMAT.
Step 1 − When you click on a chart, CHART TOOLS comprising of DESIGN and FORMAT tabs appear on the Ribbon.
![Design Format](/excel_charts/images/design_format.jpg)
Step 2 − Click the DESIGN tab on the Ribbon. The Ribbon changes to the DESIGN commands.
![Design Tab](/excel_charts/images/design_tab.jpg)
The Ribbon contains the following Design commands −
Chart layouts group
Add chart element
Quick layout
Chart styles group
Change colors
Chart styles
Data group
Switch row/column
Select data
Type group
Change chart type
Location group
Move chart
In this chapter, you will understand the design commands on the Ribbon.
Add Chart Element
Add Chart Element is the same as chart elements.
Step 1 − Click Add Chart Element. The chart elements appear in the drop-down list. These are same as those in the chart elements list.
![Add Chart Element](/excel_charts/images/add_chart_element.jpg)
Refer to the chapter – Chart Elements in this tutorial.
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 − On the Ribbon, click Quick Layout. Different predefined layout options will be displayed.
![Quick Layout](/excel_charts/images/quick_layout.jpg)
Step 2 − Move the pointer across the predefined layout options. The chart layout changes dynamically to the particular option.
Step 3 − Select the layout you want. The chart will be displayed with the chosen layout.
![Select Layout](/excel_charts/images/select_layout.jpg)
Change Colors
The functions of Change Colors are the same as Chart Styles → COLOR.
Step 1 − On the Ribbon, click Change Colors. The color schemes appear in the drop-down list. These are the same as that appear in Change Styles → COLOR.
![Colors Changing](/excel_charts/images/colors_changing.jpg)
Refer to the chapter – Chart Styles in this tutorial.
Chart Styles
The Chart Styles command is the same as Chart Styles → STYLE.
![Chart Styles](/excel_charts/images/style_charts.jpg)
Refer to the chapter – Chart Styles in this tutorial.
Switch Row/Column
You can use Switch Row/Column to change the data being displayed on X-axis to be displayed on Y-axis and vice versa.
![Switch Row/Column](/excel_charts/images/switch_row_column.jpg)
Click Switch Row / Column. The data will be swapped between X-axis and Y-axis on the chart.
![Data is Swapped](/excel_charts/images/data_is_swapped.jpg)
Select Data
You can use Select Data to change the data range included in the chart.
![Select Data](/excel_charts/images/select_data.jpg)
Step 1 − Click Select Data. A Select Data Source window appears.
![Select Data Source Window](/excel_charts/images/select_data_source_window.jpg)
This window is the same as that appears with Chart Styles → Select data.
![Select Data](/excel_charts/images/data_select.jpg)
Step 2 − Select the chart data range in the select data source window.
Step 3 − Select the data that you want to display on your chart form the Excel worksheet.
Change Chart Type
You can use the Change Chart Type button to change your chart to a different chart type.
Step 1 − Click Change Chart Type. A Change Chart Type window appears.
![Change Chart Type](/excel_charts/images/change_chart_type.jpg)
Step 2 − Select the chart type you want.
Your chart will be displayed with the chart type you want.
Move Chart
You can use Move Chart to move the chart to another worksheet in the workbook.
Step 1 − Click the Move Chart command button. A Move Chart window appears.
![Move Chart](/excel_charts/images/move_chart.jpg)
Step 2 − Select New Sheet. Type the name of the new sheet.
The chart moves from the existing sheet to the new sheet.