Explain what a combination chart is and how you can create one.

What will be an ideal response?


A combination chart is two charts in one; a column chart with a line chart, for example. This type of chart is helpful when charting dissimilar but related data. For example, you can create a combination chart based on home price and home size data, showing home prices in a column chart, and related home sizes in a line chart. Here a secondary axis (such as a vertical axis on the right side of the chart) would supply the scale for the home sizes. To create a combination chart, select all the data you want to plot, click Recommended Charts in the Charts group in the Insert tab, click the All Charts tab, select Combo, supply the series information that conforms to the chart you want to create, then click OK. To change an existing chart to a combination chart, select the chart , then click Change Chart Type in the Type group on the Chart Tools Design tab. Click Combo in the Change Chart Type dialog box, select the Secondary Axis box for each data series you want to plot, change the chart type to Line, then click OK.

Computer Science & Information Technology

You might also like to view...

A Communications Controller in SNA is responsible for

a. controlling communications links b. routing data in the network c. connecting directly to the Host Processor d. all of the above

Computer Science & Information Technology

Which of the following is NOT an aggregate function?

A) COUNT B) AVG C) MINIMUM D) PMT

Computer Science & Information Technology

The company with which you have a contract to provide television programs is referred to as a(n) ________

Fill in the blank(s) with correct word

Computer Science & Information Technology

_______________ fiber transmits multiple light signals at the same time, each using a different reflection angle within the core of the cable.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology