Excel chart wizard

Home >> Excel chart wizard

ChartWizard is a very useful feature of MS Excel for creating different types of charts. A Chart is a graphical representation of data for easy understanding and effective communication. Charts are built by sorting and relating values of selected data in the Worksheet. Only a few variables and their values are used to present a summary of the results that help in finding out trends and patterns in the data. Calculations may be involved for analysis. Charts are also known as Graphs in common parlance.


Here we’ve attempted to take you through a step-by-step process on how to make a chart using ChartWizard. There are many types of charts you can create using Excel ChartWizard such as Line Chart, column Chart, Pie chart etc. For our purpose, we’ll learn how to make a column chart here.


After you’ve created the Excel sheet and entered data in it to use as the input data for your chart, select the data you want to put on the chart along with the title and their values. Then, open ChartWizard by clicking on its icon on the toolbar menu or go to insert and select Chart. Excel will automatically guide you through 4 steps one after another to help you create a chart based on the information and formatting you choose.


Step 1: Opening ChartWizard will open a “Chart Type” dialog box. Choose Chart from “Standard Types” tab and then choose “Column” from “Chart Type” panel on left-side window pane of the dialog box and choose “Clustered Column” from “Chart Sub-type” panel on the right-side tab. To create more advanced and custom-built charts, choose “Customs Type” tab at the top of the dialog box. To go to second step, click Next.


Step 2: Now you will see a preview of the chart, built from the selected data on your worksheet, on top of the “Chart Source Data” dialog box. Below the preview display, you can see under “Data range” the range of cells from first selected cell reference to the last. Make sure you’ve selected the right cells. To move on to step-3 click Next.


Step 3: Another dialog box would appear to help you determine Chart Options. You’ll find here various options for formatting. For our purpose, however, we’ll just add titles and categories to complete a chart. Clicking on “Title” tab will open title and categories fields. Fill in the chart title and the two variables you want to compare in the categories fields. These two will be laid out as X-axis and Y-axis on the chart. Click Next.


Step 4: “Chart Location” dialog box will ask you to choose the location where you want to place the chart. You’ll be given two options: to place “As object in” the same sheet along with the original data there or “As new sheet” of the workbook you’re working on. Choose any one of them and click Finish.


Your chart is created now. If you have created a chart in the same sheet, you may find it overlapping you data. You can drag and place the data with your mouse below the data in the sheet..


It’s not difficult to see just how much effort goes behind creating a chart. You need to go through a time-consuming and tiresome process of finding, sorting, entering and editing data to create an Excel spreadsheet. Again, you have to go through all the hassles of a chart creation process. What an ordeal it would be if you had to experience corruption of data in your Excel sheets or loss of one or all charts you took all the effort and care in the world to build! It’s true that data in your Excel workbook or Excel Chart is liable to get damaged and corrupted as any other file type on your drives. If you’re experiencing corruption in the Excel files and are not able to open your Excel files or Excel charts, use Stellar Phoenix Excel Recovery Software to repair the corrupted files and recover them successfully. Repairing and recovering data through this software is much simpler than creating a chart.