Area view

BY J. CARLTON COLLINS, CPA

Q: I am trying to prepare an area chart in Excel 2010 with multiple ranges of data, but no matter which sort order I use, some of the underlying data remains obscured (see below). What is the best way to fix this?

A: It appears that your best solution is to use a line chart instead of an area chart, but assuming an area chart is the chart type you desire, you should change the area chart’s solid fill colors to semitransparent fill colors as follows. Right-click on a data series in your chart and select Format Data Series from the popup menu. Select Fill, Solid fill, and then, from the Fill Color section, select a color from the Color dropdown box and slide the Transparency chevron to 50%. Repeat this procedure for each data area in your chart (selecting a unique fill color each time), then close the dialog box. The result is an area chart in which all data areas are displayed semitransparently, so you can see each data set as shown in the example below.

SPONSORED REPORT

Tax reform changes are now in effect

With all the recent tax law changes, this year it’s more important than ever to make sure your clients’ tax situations are squared away before year end. This report provides necessary guidance to ensure 2019 starts without a hitch.

PODCAST

Using drones to enhance audits

Hermann Sidhu, CPA, global assurance digital leader at EY, walks us through EY’s exciting new project to use drones to help audit large warehouses and outdoor inventories.