Clustered Column – LineĬlustered Column–Line chart is used to highlight the different types of information. In this chapter, you will understand when each of the Combo chart types is useful. Step 5 − Double-click the chart type that suits your data. A preview of that chart type will be shown on the worksheet. Step 4 − Point your mouse on each of the icons. Clustered Column – Line on Secondary Axis.You will see the different types of available Combo charts.Ī Combo chart has the following sub-types − Step 3 − On the INSERT tab, in the Charts group, click the Combo chart icon on the Ribbon Step 1 − Arrange the data in columns and rows on the worksheet. Follow the steps to insert a Combo chart in your worksheet. The scale of the secondary vertical axis shows the values for the associated data series. You can plot one or more data series on a secondary vertical (Value) axis. You have mixed type of data (for example, price and volume). The numbers in your data vary widely from data series to data series, or Shown with a secondary axis, this chart is even easier to read. Combo charts combine two or more chart types to make the data easy to understand.
0 Comments
Leave a Reply. |