Go to the Design tab in the ribbon, select “Change Chart Type” and choose a Line chart type. Excel should have created a column chart showing two data series (price and volume).Ĭ) Select the chart area, go to the Layout tab (in the ribbon), click on the drop-down menu of the Chart Elements box (on the left hand-side of the ribbon) and select the Price data series. In the example below, price is plotted using a line chart, whereas volume is plotted using a column chart.Ī) Select the entire table of data, including headersī) Select the Insert menu and add a column chart (such as the 2-D Clustered Column). This article will take you through the creation of both a simple and a complex combo chart in Excel.Ī simple example of a combo chart is a price-volume chart. Simple combo charts can be created quickly, but more complex charts require special procedures. However, sometimes you may need to produce presentations that combine different types of charts together, resulting in a combination chart or “combo” chart.Ī specific procedure is required to produce combo charts in Excel. The standard chart types available in Excel are usually sufficient for most presentational needs.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |