Academic journal article Journal of Accountancy

Combination Charts

Academic journal article Journal of Accountancy

Combination Charts

Article excerpt

Q Is it possible to overlay one chart atop another chart in Excel 2013 for comparison purposes?

A Yes, chart overlays are possible. Excel allows you to produce a combination chart that places one chart atop another using a percentage scale for each of the two data ranges. This arrangement allows the reader to visually compare the figures to determine if any relationships exist between the two sets of data in a single chart. For example, consider the data shown above, which summarize a firm's monthly billable hours and monthly revenue. Following are steps for creating a combination chart using these data:

1. Create a 2-D Line chart. Start by creating a 2-D Line chart using the entire data range by highlighting the data (A3:C15 in this example) and then from the Insert tab, in the Charts group, select the 2-D Line option.

[ILLUSTRATION OMITTED]

2. Separate the data into two chart axes. Right-click one of the chart lines (either one), and from the pop-up menu select Format Data Series. In the resulting Format Data Series panel, click the Series Options icon, select the Secondary Axis option, and then click Close. This action will create a separate axis for each set of data in the same chart. (Note that data labels are now displayed on both sides of the chart at the top of the next column.)

3. Change one of the lines to display bars. Click one of the lines to select it (either one is fine), then right-click that selected line and from the pop-up menu select Change Series Chart Type. …

Search by... Author
Show... All Results Primary Sources Peer-reviewed

Oops!

An unknown error has occurred. Please click the button below to reload the page. If the problem persists, please try again in a little while.