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

[mach3]

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.]

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]

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