Chart - w/ 1 column and 2 lines - NEED HELP!

mach3 · May 7th, 2002, 08:50 AM

i have 3 rows of data. let's call them 2002, 2001, 2000.

i want to create a chart with 2002 as columns and 2001 and 2002 as just data lines or data points.

in CUSTOM TYPES of the Chart Wizard, there is an option called 'Line - Column'. the problem with this one is that i get 2 columns and 1 line; i need 1 column and 2 lines. how do i do that? please help!

mach3

Mark W. · May 7th, 2002, 09:00 AM

Right-click on your chart's 2nd series (the one for 2001), choose Chart Type... from the popup menu, and double-click the Line chart type.

mach3 · May 7th, 2002, 09:15 AM

i was RIGHT there. didn't know you could do that. thanks. i will apply this to most other dead-end situations in the future.

mach3

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

May 7th, 2002, 08:50 AM	#1
mach3 Board Regular Join Date: Mar 2002 Posts: 246	i have 3 rows of data. let's call them 2002, 2001, 2000. i want to create a chart with 2002 as columns and 2001 and 2002 as just data lines or data points. in CUSTOM TYPES of the Chart Wizard, there is an option called 'Line - Column'. the problem with this one is that i get 2 columns and 1 line; i need 1 column and 2 lines. how do i do that? please help! mach3

May 7th, 2002, 09:00 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Right-click on your chart's 2nd series (the one for 2001), choose Chart Type... from the popup menu, and double-click the Line chart type.

May 7th, 2002, 09:15 AM	#3
mach3 Board Regular Join Date: Mar 2002 Posts: 246	i was RIGHT there. didn't know you could do that. thanks. i will apply this to most other dead-end situations in the future. mach3