| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
| Bar Chart To Line Chart for last 3 points only | Charts and Charting in Excel | |||
| How do I alter the number of bar series in a combination chart? | Charts and Charting in Excel | |||
| Dynamic series in Chart | Charts and Charting in Excel | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
Linear Mode
