Combination chart - want only ONE series showing as a line, not 2.
I want to create a combination chart, on one axis, with 4 series showing in
columns and one in a line. When I choose the Line-Column chart option, it plots the last two series as a line and the first three in columns. How can I change the one series to show as a column like the others? Thanks very much in advance for your help. |
Combination chart - want only ONE series showing as a line, not2.
Hi,
Rather than use the built-in combination charts roll your own. Start with a 5 series column chart and then select the series that you want as a line chart. Right click it and pick Chart Type from the popup menu. From the chart type dialog pick the required Line chart. Cheers Andy sincaa wrote: I want to create a combination chart, on one axis, with 4 series showing in columns and one in a line. When I choose the Line-Column chart option, it plots the last two series as a line and the first three in columns. How can I change the one series to show as a column like the others? Thanks very much in advance for your help. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 03:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com