Excel charts

Kerrilea · Mar 19th, 2002, 12:45 AM

HELP!!! Im a newbie at Excel having just started a course at tech. I need to know how to make a combination bar/line chart and need it explained as simply as possible

. Please help

Mark W. · Mar 19th, 2002, 07:38 AM

I suspect that you mean a combination Line-Column chart. See the Excel Help topic for "Combination charts for showing mixed data" for an illustration. As for creating the chart I recommend that you consult the Excel Help topic for "Create a chart" and use the Chart Wizard as a step-by-step guide.

Kerrilea · Mar 22nd, 2002, 04:28 AM

Mark Thanks so much for your advice Youve saved my life

BarrettM · Mar 22nd, 2002, 07:11 AM

If you create the chart as one type , then highlight the data series which you want to be of a different type, click chart type and then from the list, you can select the second type of chart you want.

Matt · Mar 22nd, 2002, 07:40 AM

I think this only works with 2D charts, i.e. you cannot have a line chart over a 3D column chart - not with Excel 97 anyway

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 12:45 AM	#1
Kerrilea New Member Join Date: Mar 2002 Location: Australia Posts: 2	HELP!!! Im a newbie at Excel having just started a course at tech. I need to know how to make a combination bar/line chart and need it explained as simply as possible . Please help

Mar 19th, 2002, 07:38 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	I suspect that you mean a combination Line-Column chart. See the Excel Help topic for "Combination charts for showing mixed data" for an illustration. As for creating the chart I recommend that you consult the Excel Help topic for "Create a chart" and use the Chart Wizard as a step-by-step guide.

Mar 22nd, 2002, 04:28 AM	#3
Kerrilea New Member Join Date: Mar 2002 Location: Australia Posts: 2	Mark Thanks so much for your advice Youve saved my life

Mar 22nd, 2002, 07:11 AM	#4
BarrettM Board Regular Join Date: Mar 2002 Location: Northern Ireland Posts: 113	If you create the chart as one type , then highlight the data series which you want to be of a different type, click chart type and then from the list, you can select the second type of chart you want.

Mar 22nd, 2002, 07:40 AM	#5
Matt Board Regular Join Date: Feb 2002 Location: England Posts: 212	I think this only works with 2D charts, i.e. you cannot have a line chart over a 3D column chart - not with Excel 97 anyway