To create an Area Chart, arrange the data in columns or rows on the worksheet.Īn Area Chart has the following sub-types − By showing the sum of the plotted values, an area chart also shows the relationship of parts to a whole. To create a Bar Chart, arrange the data in columns or rows on the Worksheet.Ī Bar Chart has the following sub-types −Īrea Charts can be used to plot the change over time and draw attention to the total value across a trend. In a Bar Chart, the categories are organized along the vertical axis and the values are organized along the horizontal axis. Bar Chartīar Charts illustrate comparisons among individual items. To create a Doughnut Chart, arrange the data in columns or rows on a worksheet. It is similar to a Pie Chart with the only difference that a Doughnut Chart can contain more than one data series, whereas, a Pie Chart can contain only one data series.Ī Doughnut Chart contains rings and each ring representing one data series. To create a Pie Chart, arrange the data in one column or row on the worksheet.Ī Pie Chart has the following sub-types −Ī Doughnut chart shows the relationship of parts to a whole. The data points in a pie chart are shown as a percentage of the whole pie. Pie charts show the size of items in one data series, proportional to the sum of the items. To create a Line chart, arrange the data in columns or rows on the worksheet.Ī Line chart has the following sub-types − Value data is distributed evenly along the vertical axis.Category data is distributed evenly along the horizontal axis.Therefore, they are ideal for showing trends in data at equal intervals, such as months, quarters or years. Line charts can show continuous data over time on an evenly scaled Axis. To create a column chart, arrange the data in columns or rows on the worksheet.Ī column chart has the following sub-types − Column ChartĪ Column Chart typically displays the categories along the horizontal (category) axis and values along the vertical (value) axis. In this chapter, you will have an overview of the different chart types and get to know the sub-types for each chart type. You can also change the chart type later.Įxcel offers the following major chart types −Įach of these chart types have sub-types. Based on the type of data, you can create a chart. Excel Charts - TypesĮxcel provides you different types of charts that suit your purpose. Step 7 − Give a meaningful title to the chart by editing Chart Title. The chart will be displayed in your worksheet. Step 6 − Select the type of chart you like, click OK. More Recommended Charts will be displayed. Previews of the available charts will be shown. Step 4 − Point the mouse over the Recommended Charts. Recommended Charts for your data will be displayed. The Quick Analysis toolbar appears with the options FORMATTING, CHARTS, TOTALS, TABLES, SPARKLINES. Creating Charts with Quick Analysisįollow the steps given to create a chart with Quick Analysis.Ī Quick Analysis button appears at the bottom right of your selected data. 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 5 − Click on a chart type to see the preview on the right side. Step 4 − Browse through the Recommended Charts. To use the option Recommended Charts, follow the steps given below −Ī window displaying the charts that suit your data will be displayed, under the tab Recommended Charts.
If the chart type you selected is not working with your data.
You are not sure of the chart type that suits your data. You can use the Recommended Charts option if − Step 6 − Give a meaningful title to the chart by editing Chart Title. Step 4 − Move through the Column Chart options to see the previews. Further, More Column Charts… option is also displayed. The 2-D column, 3-D Column chart options are displayed. Step 3 − Click the Insert Column Chart on the Ribbon. Step 2 − Click the Insert tab on the Ribbon.
To create charts using the Insert Chart tab, follow the steps given below. In this chapter, we will learn to create charts. The Recommended Charts command on the Insert tab helps you to create a chart that is just right for your data.Ī window displaying the charts that suit your data will be displayed. When you click on a chart, a new tab Chart Tools is displayed on the ribbon. It helps you find a chart suitable to your data with the button Recommended Charts. The Charts group is formatted in such a way that − The Charts group on the Ribbon looks as follows − You can find the Charts group under the INSERT tab on the Ribbon. A chart is a visual representation of data, in which the data is represented by symbols such as bars in a bar chart or lines in a line chart.
In Microsoft Excel, charts are used to make a graphical representation of any set of data.