What is the first step in creating a chart in Excel?
The tutorial explains the Excel charts basics and provides the detailed guidance on how to make a graph in Excel. You will also learn how to combine two chart types, save a graph as chart template, change the default chart type, resize and move the graph. Show
Everyone needs to create graphs in Excel to visualize data or check on the latest trends. Microsoft Excel provides a wealth of powerful chart features, but it may be challenging to locate the necessary options. Unless you have a good understanding of various chart types and data types they are appropriate for, you may spend hours fiddling with different chart elements and yet end up creating a graph that bears only remote resemblance to what you've pictured in your mind. This chart tutorial starts with the basics and walks you through the process of making a chart in Excel step-by-step. And even if you are a beginner with little to no experience, you will be able to create your first Excel graph in minutes and make it look exactly the way you want it to look. Excel charts basicsA chart, also known as graph, is a graphical representation of numeric data where the data is represented by symbols such as bars, columns, lines, slices, and so on. It is common to make graphs in Excel to better understand large amounts of data or relationship between different data subsets. Microsoft Excel lets you create a great lot
of different graph types such as Column chart, Bar chart, Line chart, Pie chart, Area chart, Bubble chart, Stock, Surface, Radar charts, and PivotChart. Excel charts have a handful of elements. Some of these elements are displayed by default, others can be added and modified manually as needed.
How to make a graph in ExcelWhen creating graphs in Excel, you can select from a variety of chart types to present your data in the way most meaningful to your users. You can also make a combination graph by using several chart types. To create a chart in Excel, you start by entering the numeric data on a worksheet, and then continue with the following steps. 1. Prepare the data to plot in a chartFor most Excel charts, such as bar charts or column charts, no special data arrangement is required. You can organize the data in rows or columns, and Microsoft Excel will automatically determine the best way to plot the data in your graph (you will be able to change this later). To make a good-looking Excel chart, the following points could be helpful:
In this example, we are going to make a graph based on the following table. 2. Select data to include in the chartSelect all the data you want to include in your Excel graph. Be sure to select the column headings if you want them to appear either in the chart legend or axis labels.
Tip. To select all used cells on the worksheet, place the cursor in the first cell of the used range (press Ctrl+Home to get to A1), and then press Ctrl + Shift + End to extend the selection to the last used cell (the lower-right corner of the range). 3. Inset the chart in Excel worksheetTo add the graph on the current sheet, go to the Insert tab > Charts group, and click on a chart type you would like to create. In Excel 2013 and higher, you can click the Recommended Charts button to view a gallery of pre-configured graphs that best match the selected data. In this example, we are creating a 3-D Column chart. To do this, click the arrow next to the Column Chart icon and choose one of the chart sub-types under the 3-D Column category. For more chart types, click the More Column Charts… link at the bottom. The Insert Chart dialog window will open, and you will see a list of available column chart sub-types at the top. You can also choose other graph types on the left hand side of
the dialog. Tip. To immediately see all available chart types, click the Dialog Box Launcher next to Charts. Well, basically, you are done. The graph is placed on your current worksheet as an embedded chart. Here's the 3-D Column chart created by Excel for our data: The chart already looks nice, and still you may want to make a few customizations and improvements, as explained in Customizing Excel charts section. Tip. And here are some useful tips to make your graphs more functional and better looking: Excel Charts: tips, tricks and techniques. Create a combo graph in Excel to combine two chart typesIf you want to compare different data types in your Excel graph, creating a combo chart is the right way to go. For example, you can combine a column or area chart with a line chart to present dissimilar data, for instance an overall revenue and the number of items sold. In Microsoft Excel 2010 and earlier versions, creating a combination chart was a cumbersome task, the detailed steps are explained by the Microsoft team in the following article: Combining chart types, adding a second axis. In Excel 2013 - Excel 365, those long-winded guidelines turn into four quick steps.
Finally, you may want to add some finishing touches, such as typing your chart title and adding axis titles. The completed combination chart may look
similar to this: Customizing Excel chartsAs you have just seen, making a chart in Excel is easy. But after you've added a chart, you may want to modify some of the default elements to create an exquisite eye-catching graph. The most recent versions of Microsoft Excel introduced many improvements in chart features and added a new way to access the chart formatting options. Overall, there are 3 ways to customize charts in Excel 365 - 2013.
Hopefully, this quick overview of the chart customization features has helped you to get the general idea of how you can modify graphs in Excel. In the next tutorial, we will have an in-depth look at how to customize different chart elements, such as:
Saving your favorite graph as Excel chart templateIf you are really happy with the chart you've just created, you can save it as a chart template (.crtx file) and then apply that template to other graphs you make in Excel. How to create a chart templateTo save a graph as a chart template, right-click the chart and pick Save as Template in the pop-up menu: In Excel
2010 and older versions, the Save As Template feature resides on the ribbon, on the Design tab > Type group. Clicking the Save As Template option brings up the Save Chart Template dialog, where you
type the template name and click the Save button. By default, the newly created chart template is saved to the special Charts folder. All chart templates stored to this folder are automatically added to the Templates folder that appears in the Insert Chart and Change Chart Type dialogs when you create a new or modify an existing graph in Excel. Please keep in mind that only the templates that were saved to the Charts folder appear in the Templates folder in Excel. So, make sure you don't change the default destination folder when saving a template. Tips:
How to apply the chart templateTo create a chart in Excel based on a specific chart template, open the Insert Chart dialog by
clicking the Dialog Box Launcher in the Charts group on the ribbon. On the All Charts tab, switch to the Templates folder, and click on the template you want to apply. To apply the
chart template to an existing graph, right click on the graph and choose Change Chart Type from the context menu. Or, go to the Design tab and click Change Chart Type in the Type group. Either way, the Change Chart Type dialog will open, you find the desired template in the Templates folder and click on it. How to delete a chart template in ExcelTo delete a graph template, open the Insert Chart dialog, go to the Templates folder and click the Manage Templates button in the bottom left corner. Clicking the Manage Templates button will open the Charts folder with all existing templates. Right click on the template you want to remove and choose Delete in the context menu. Using the default chart in ExcelExcel's default chart is a real time-saver. Whenever you need a graph in a hurry or just want to have a quick look on certain trends in your data, you can make a chart in Excel with a single keystroke! Simply select the data to be included in the graph and press one of the following shortcuts:
How to change the default chart type in ExcelWhen you make a graph in Excel, the default chart format is a two-dimensional column chart. To change the default graph format, perform the following steps:
Resizing the chart in ExcelTo resize the Excel graph, click on it, and then drag the sizing handles to the size you want. Alternatively, you can enter the desired chart height and width in the Shape Height and Shape Width boxes on
the Format tab, in the Size group: For more options, click the Dialog Box Launcher next to
Size and configure the needed parameters on the pane. Moving the chart in ExcelWhen you create a graph in Excel, it is automatically embedded on the same worksheet as the source data. You can move the chart to any location on the sheet by dragging it with the mouse. If you find it easier to work with a graph on a separate sheet, you can move it there in the following way.
If you want to move the chart to an existing sheet, check the Object In option, and then select the needed worksheet in the drop-down list. To export the chart somewhere outside of Excel, right-click on the chart border and click Copy. Then open another program or application and paste the graph there. You can find a few other chart saving techniques in the following tutorial: How to save Excel chart as image. This is how you make charts in Excel. Hopefully, this overview of the basic chart features has helped you get off on the right foot. In the next tutorial, we will provide the detailed guidance on customizing different chart elements such as chart title, axes, data labels and so on. In the meantime, you may want to review other chart tutorials that we have (the links are at the end of this article). I thank you for reading and look forward to seeing you on our blog next week! You may also be interested inWhat are the steps to create a chart in Excel?Create a chart. Select the data for which you want to create a chart.. Click INSERT > Recommended Charts.. On the Recommended Charts tab, scroll through the list of charts that Excel recommends for your data, and click any chart to see how your data will look. ... . When you find the chart you like, click it > OK.. What are the four steps of creating a chart?Create a chart in four easy steps to learn more about ABC Company's profits.. Step 1: Select the Data. In our example, we'll select the row and column headings, plus the data for the regions and the quarters. ... . Step 2: Insert the Chart. ... . Step 3: Move and/or Resize the Chart. ... . Step 4: Add/Remove Chart Elements.. What are the steps in creating a chart in Microsoft?In your Word document, click Insert > Chart. Select the type of chart you want, such as column or pie chart, and click OK. (If you're not sure which to choose, move down the All Charts list to preview each type.) Enter your data into the spreadsheet that automatically opens with the chart.
What is the first step of chart Wizard?The Chart Wizard starts at Step 1 by asking what type of chart to make (see screen shot ). Select a chart type and sub-type that works best for your data and click the Next button. At Step 2 of the Chart Wizard, observe if chart is displaying the data correctly.
|