A Line-Column Chart: How do I specify which series should be

Feb 22nd, 2002, 01:34 PM

I have been trying to make a chart that shows one data series as a Line. Then I want to add 2 or 3 data series as Columns. However, Excel chooses arbitrarily which data series to make Column or Line. I seem to have no choice in the matter. How do I choose?

Juan Pablo González · Feb 22nd, 2002, 01:58 PM

Well, you DO have a choice.

Click on the serie that you want to be a column, and in the chart toolbar, select that chart type. Now, select the other serie, and do the same, but this time select a line type.

Feb 22nd, 2002, 02:06 PM

You are the Man! Thanks!!! It worked!

Feb 22nd, 2002, 01:58 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Well, you DO have a choice. Click on the serie that you want to be a column, and in the chart toolbar, select that chart type. Now, select the other serie, and do the same, but this time select a line type. __________________ Regards, Juan Pablo González http://www.juanpg.com

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

Feb 22nd, 2002, 01:34 PM	#1
Guest Posts: n/a	I have been trying to make a chart that shows one data series as a Line. Then I want to add 2 or 3 data series as Columns. However, Excel chooses arbitrarily which data series to make Column or Line. I seem to have no choice in the matter. How do I choose?

Feb 22nd, 2002, 02:06 PM	#3
Guest Posts: n/a	You are the Man! Thanks!!! It worked!