At the left end of the Ribbon, in the Current Selection group,. On the Ribbon, click the Layout tab, under Chart Tools. On the worksheet, click on the chart to select it. In this example, the Cases series is difficult to see, so you can To make the Cases series stand out, we'll change it to a line series,Īnd later we'll plot that line graph on a separate axis. 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?
0 kommentar(er)
