But a reader of this site wrote to me and remarked that an area chart series is a handy way to add a fill to the background of a chart. This was just intended as a demonstration of the techniques needed to make a customized combination chart in Excel. I couldn't imagine why you would need a combination Line-Column-Area chart.
Then I selected the entire chart, selected Chart Options from the Chart menu, and on the Axes tab, I unchecked the secondary axis boxes (see below). from the Format menu, and on the Axes tab, selected Secondary Axis. First I selected the area chart series (Series A), picked Selected Data Series. To fix this, I followed a two step process. The result is a little funny, because now the first and last bars straddle the ends of the plot area. Then I selected Series A, went back to the Chart menu, selected Chart Type, and picked out an unstacked Area chart style. I selected Series B, went to the Chart menu, selected Chart Type, and picked out a Column chart style. The first chart is a simple line chart using the sample data. To show the technique, I took the following sample data, and created a number of different combination charts.
You can create your chart, then one-by-one change the style of each series to get the unique combinations you want. You aren't limited to the default collection provided by Excel, however. But these are limited, with only a few series permitted, and you have to arrange the series in the right order on your worksheet. Excel offers a very small number of combination charts from the Custom Charts tab of the Chart Wizard: Column-Area and a few Line-Column varieties.
0 kommentar(er)
