![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 - Creating Charts
In this chapter, we will learn to create charts.
Creating Charts with Insert Chart
To create charts using the Insert Chart tab, follow the steps given below.
Step 1 − Select the data.
Step 2 − Click the Insert tab on the Ribbon.
Step 3 − Click the Insert Column Chart on the Ribbon.
![Creating Charts with Insert Chart](/excel_charts/images/creating_charts_with_insert_chart.jpg)
The 2-D column, 3-D Column chart options are displayed. Further, More Column Charts… option is also displayed.
![Column Charts Display](/excel_charts/images/column_charts_display.jpg)
Step 4 − Move through the Column Chart options to see the previews.
Step 5 − Click Clustered Column. The chart will be displayed in your worksheet.
![Clustered Column](/excel_charts/images/clustered_column.jpg)
Step 6 − Give a meaningful title to the chart by editing Chart Title.
![Chart Title](/excel_charts/images/chart_title.jpg)
Creating Charts with Recommended Charts
You can use the Recommended Charts option if −
You want to create a chart quickly.
You are not sure of the chart type that suits your data.
If the chart type you selected is not working with your data.
To use the option Recommended Charts, follow the steps given below −
Step 1 − Select the data.
Step 2 − Click the Insert tab on the Ribbon.
Step 3 − Click Recommended Charts.
A window displaying the charts that suit your data will be displayed, under the tab Recommended Charts.
![Creating Charts with Recommended Charts](/excel_charts/images/creating_charts_with_recommended_charts.jpg)
Step 4 − Browse through the Recommended Charts.
Step 5 − Click on a chart type to see the preview on the right side.
![Chart Type](/excel_charts/images/chart_type.jpg)
Step 6 − Select the chart type you like. Click OK. The chart will be displayed in your worksheet.
![Select Chart Type](/excel_charts/images/select_chart_type.jpg)
If you do not see a chart you like, click the All Charts tab to see all the available chart types and pick a chart.
Step 7 − Give a meaningful title to the chart by editing Chart Title.
![Edit Chart Title](/excel_charts/images/edit_chart_title.jpg)
Creating Charts with Quick Analysis
Follow the steps given to create a chart with Quick Analysis.
Step 1 − Select the data.
A Quick Analysis button appears at the bottom right of your selected data.
![Creating Charts with Quick Analysis](/excel_charts/images/creating_charts_with_quick_analysis.jpg)
Step 2 − Click the Quick Analysis icon.
The Quick Analysis toolbar appears with the options FORMATTING, CHARTS, TOTALS, TABLES, SPARKLINES.
![Quick Analysis Toolbar](/excel_charts/images/quick_analysis_toolbar.jpg)
Step 3 − Click the CHARTS option.
Recommended Charts for your data will be displayed.
![Click the CHARTS](/excel_charts/images/click_charts.jpg)
Step 4 − Point the mouse over the Recommended Charts. Previews of the available charts will be shown.
![Previews of the available charts](/excel_charts/images/previews_of_available_charts.jpg)
Step 5 − Click More.
![Click More](/excel_charts/images/click_more.jpg)
More Recommended Charts will be displayed.
![More Recommended Charts](/excel_charts/images/more_recommended_charts.jpg)
Step 6 − Select the type of chart you like, click OK. The chart will be displayed in your worksheet.
Step 7 − Give a meaningful title to the chart by editing Chart Title.
![Chart Title](/excel_charts/images/chart_title.jpg)