Smaller than the Amounts, it's hard to see the Cases series in the chart. Each series name is shown in as a legend entry, with a colour code beside it.Amounts are shown on the vertical axis (y-axis).Product names are shown in the axis labels on the horizontal axis (x-axis).Amounts, the second series, are in the red column.Cases, the first series, are in the blue column.This creates a chart that is embedded on the active worksheet, with two series - Cases and Amounts. In the drop-down menu, in the 2-D Column section, click theįirst chart type - Clustered Column chart.Then, in the Chart group, click the Column button.Next, on the Excel Ribbon, click the Insert tab.Select any cell in the chart data range - B4:D8.We'll change one series in the Excel graph to a line chart. There is a worksheet heading in cell B2 - Product Sales.įirst, we'll create a column chart from all of the data, and later The total could be included in the chart, but I've left it out in this example.The example shown below, the product name, number of cases sold, andĪt the bottom of the list, in cells B9:D9, the total amounts are calculated, using There are step-by-step written instructionsįirst, set up your data for the chart, on an Excel worksheet.

To see the steps for creating a line-column chart, please If you use two differentĬhart types in a single chart, it's called a combination chart (or combo chart), like In a different chart type, such as a line chart. You select a specific chart type, such as a columnĬhart, and all of the series are created with that chart type.įor some charts, you might prefer to see one or more of the series In Microsoft Excel, you can select data on a worksheet, and insert a chartīased on that data. Get the Sample File What Is a Combination Chart?

How to make a pie chart in excel 2003