Excel Functions Tutorials
- Excel Charts
- Types of Charts in Excel
- Area Chart in Excel
- Bubble Chart in Excel
- Chart Templates in Excel
- Change Chart Style in Excel
- Calendar Template in Excel
- Inventory Template in Excel
- Clustered Bar Chart in Excel
- Clustered Column Chart in Excel
- Column Chart in excel
- Combination Charts in Excel (Combo)
- Excel Combo Chart
- Control Charts in Excel
- Doughnut Chart in Excel
- Dynamic Chart in Excel
- Excel Chart Wizard
- Flow Chart in Excel
- Flowchart Excel Examples
- Funnel Chart in Excel
- Gantt Chart in Excel
- Gantt Chart Example
- Gauge Chart in Excel (Speedometer)
- Graphs vs Charts
- Histogram Excel Chart
- How to Make Graph / Chart in Excel?
- Legends in Excel Chart
- Line Graphs / Charts in Excel
- Line Chart Examples
- Marimekko Chart in Excel (Mekko)
- Normal Distribution Graph in Excel
- Organization Chart in Excel
- Pareto Chart in Excel
- Pie Chart in Excel
- Make Pie Chart in Excel
- Pivot Chart in Excel
- Radar Chart in Excel (Spider Chart)
- Stacked Chart in Excel (Column, Bar & 100% Stacked)
- Stacked Bar Chart in Excel
- Stacked Column Chart
- Stock Chart in Excel
- Scatter Plot in Excel (Chart)
- Tornado Chart in Excel
- Dot Plots in Excel
- 3D Plot in Excel
- 3D Scatter Plot in Excel
- Standard Deviation Graph in Excel
- S Curve in Excel
- Waterfall Chart in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Tools (98+)
- Excel Tips (178+)
- VBA (162+)
- Power Bi (35+)
Excel Chart Wizard in excel is a type of wizard which takes any user or guides them to a step by step process to insert a chart in an excel spreadsheet, it was available in excel older versions as the name of chart wizard and for the newer versions we have recommended charts option where excel itself recommends us various types of charts to choose.
Excel Chart Wizard (Table of Contents)
Chart Wizard in Excel
Excel Chart Wizard will cover all the things you should know about excel chart creation. Up until Excel 2007 version excel has its own excel wizard tool which would have guided the beginners in terms of creating charts in excel. But from excel 2007 versions they have eliminated Excel Chart Wizard and integrated sophisticated ribbon interface which is far better than the traditional Excel Chart Wizard.
If you are a fresher to excel charts and don’t know what to do with charts and how to create them in excel then this is the article tailor-made for you.
Note: I am using Excel 2013 version in this tutorial.
In recent versions of excel (from 2007) charts are integrated under INSERT tab in excel and we have a wide variety of charts available here.
Overview of the Excel Chart Wizard
Before I tell you how to build an excel chart wizard let me explain to you the body of the chart in detail. Take look at the below sample chart
This is the general overview of any chart in excel.
How to Build a Chart using the Excel Chart Wizard?
Ok, now we will see how to build the chart in excel.
Getting started is always a difficult thing but once you get used to it will be easy. First thing while creating a chart is Chart Range. This is nothing but our data.
Let’s consider the above data as our chart data. Based on this data we are going to build a chart.
When creating a chart we have any kind of charts available in excel. We have column chart, bar excel chart, line chart in excel, pie chart these are the most frequently used charts in excel. For this data, I am selecting a column chart.
Step 1: Firstly we need to select the data first. In this case, the data range is A1 to B6.
Step 2: Go to INSERT tab. Under INSERT tab go to the chart area.
Step 3: Since we have selected column chart, click on the column chart.
Step 4: Select the first chart in this.
Step 5: As soon as you click on this chart excel shows your default chart as shown in the below image.
Step 6: This isn’t a fully equipped chart. We need to make some adjustments to this chart to make it look better and beautiful.
Firstly right click on the chart and select, Select Data.
Step 7: In the below window we need only sales column to be shown as column bars, so remove Year from this list.
Step 8: After removing it, we need Years to have appeared in the X-Axis. So click on the Edit button on the right-hand side.
Step 9: Now select the Year range as the reference.
Step 10: Click on Ok to back to the previous window. Again click on OK button to complete the chart building. We have a chart ready now.
Step 11: We need to change the Change the Chart Heading to Year on Year Sales Comparison. To change the chart title double click on the chart title and enter your own chart title.
Step 12: Add Data Labels. Data Labels are nothing but each data bars actual numbers. Let’s show the Data Labels on each bar now.
Right-click on one of the bar and select Add Data Labels.
Now we can see data labels for each label.
Step 13: Next thing in the beautification process is removing gridlines. Gridlines are the tiny gray-colored line in the chart plot area.
In order to delete them select the gridline and hit delete key, we will have chart without gridlines.
Step 14: Change the color of the chart fonts to black. Select the chart and select black font color in the Home Tab.
Step 15: Since we have only one set of data in this chart remove legend from the chart.
Step 16: You can change the default column bar color to any of the colors as per your wish under the HOME tab. Select the bar and hit the color of your choice.
Things to Remember While Create Excel Chart Wizard
These are the process involved in creating a chart. Below are some points to remember here.
- Under SELECT DATA we can select and delete unwanted things.
- If the excel doesn’t give you proper X-Axis then you need to follow Step 8 & Step9.
- Show Legends only in case of two or more items. In case of single item remove legend.
This has been a guide to Excel Chart Wizard. Here we discuss How to Build an Excel Chart Wizard along with practical examples and downloadable excel template. You may learn more about excel from the following articles –