Chart Wizard in Excel

You are free to use this image on you website, templates, etc., Please provide us with an attribution linkHow to Provide Attribution?Article Link to be HyperlinkedFor eg:Source: Excel Chart Wizard (wallstreetmojo.com)

How to Build a Chart using the Excel Chart Wizard?

Let us consider the below data as our chart data. Based on this data, we are going to build a chart.

  • Step 1: Firstly, we need to select the data first. In this case, the data range is A1 to B6.

  • Step 2: We need to go to the “Insert” tab. Then, under the INSERT tabINSERT TabIn excel “INSERT” tab plays an important role in analyzing the data. Like all the other tabs in the ribbon INSERT tab offers its own features and tools. Under Insert Tab we have several other groups including tables, illustration, add-ins, charts, Power map, sparklines, filters, etc.read more, go to the “Charts” area.

  • Step 3: Since we have selected a column chart, click on the “Column Charts.”

  • Step 4: Select the first chart in this.

  • Step 5: As soon as we click on this chart, Excel shows the default chart like the one below.

  • Step 6: This is not a fully equipped chart. We need to make adjustments to this chart to look better and more beautiful.

Firstly, right-click on the chart and select “Select Data.”

  • Step 7: In the below window, we need only the “Sales” column to be shown as column bars, so we must remove “Year” from this list.

  • Step 8: After removing it, we need “Year” to appear on the X-axis. So, we must 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 the “OK” button to complete the chart building. We have a chart ready now

  • Step 11: We need to change the chart’s name to “Year on Year Sales Comparison.” To change the chart title, double-click on the chart title and enter the chart title.

  • Step 12: Add “Data Labels.” “Data Labels” are nothing but each data bar’s actual numbers. Let us show the data labels on each bar now.

Then, we need to right-click on one of the bars and select “Add Data Labels.”

Now, we can see data labels for each label.

  • Step 13: The next thing in the beautification process is removing gridlines. Gridlines in excelGridlines In ExcelGridlines are little lines made of dots to divide cells from each other in a worksheet. The gridlines have slight faint invisibility; you can find it in the page layout tab. This option has a checkbox; for activating the gridlines, you can tick on it and untick if you wish to deactivate gridlines.read more are the tiny gray-colored line in the chart plot area.

Select the gridline and press the “Delete” key to delete them. As a result, we will have a chart without gridlines.

  • Step 14: Change the color of the chart fonts to black. Select the chart and the black font color in the “Home” tab.

  • Step 15: Since we have only one set of data in this chart, we need to remove the legend from the chartLegend From The ChartExcel chart legends depict description of significant elements and provides easy access to any chart. These legends are represented with the help of colours or symbols and distinguish data for better understanding.read more.

  • Step 16: We can change the default column bar color to any of the colors as per our wish under the “Home” tab. Select the bar and choose the color of your choice.

Things to Remember

These are the processes involved in creating a chart. Below are some points to remember here.

  • It will cover all the things you should know about excel chart creation. Up until Excel 2007, version Excel had its wizard tool, which would have guided the beginners in creating charts in Excel. But, from Excel 2007 versions, they eliminated “Chart Wizard” and integrated ribbon interface excelRibbon Interface ExcelRibbons in Excel 2016 are designed to help you easily locate the command you want to use. Ribbons are organized into logical groups called Tabs, each of which has its own set of functions.read more, which is far better than the traditional “Chart Wizard.”Under “Select Data,” we can select and delete unwanted things.If Excel does not give you the proper X-axis, you need to follow Steps 8 and 9.We must show legends only in the case of two or more items. In the case of a single item, remove the legend.

This article has been a guide to Excel Chart Wizard. We discuss building an Excel chart wizard, practical examples, and a downloadable Excel template. You may learn more about Excel from the following articles: –

  • Pie Chart in ExcelExamples of Line ChartChart Templates in ExcelDynamic Excel Chart