Other Resources My Cup of Joe » Excel 2007 Question...NEED HELP! Rss Feed  
Moderators: k9car363, the bear, DerekL, alicefoeller Reply
2009-11-03 12:32 PM

User image

Master
1563
10005002525
Chicago
Subject: Excel 2007 Question...NEED HELP!

Need help-

I am trying to create a bar graph in the Excel 07 software, and I can't figure out how to create a bar graph that is showing 2 different things, and therefore, has 2 vertical axis (one on the left and one on the right) on it...I used to be able to do it in the previous excel, but now I can't figure it out???

Anyone know how?

 



2009-11-03 12:41 PM
in reply to: #2495498

User image

Pro
4827
2000200050010010010025
McKinney, TX
Subject: RE: Excel 2007 Question...NEED HELP!
I use Excel 2003 but here's a link with step by step instructions for 2007.  Link
2009-11-03 12:41 PM
in reply to: #2495498

User image

Pro
6838
5000100050010010010025
Tejas
Subject: RE: Excel 2007 Question...NEED HELP!
I'm not sure I fully understood the question. Can you post an example from a 2003 chart you made?

Edited by mdg2003 2009-11-03 12:45 PM
2009-11-03 12:46 PM
in reply to: #2495498

Iron Donkey
38643
50005000500050005000500050002000100050010025
, Wisconsin
Subject: RE: Excel 2007 Question...NEED HELP!

One graph that has two vertical bars, one bar on left and another bar on the right, correct?

See if this helps:
http://spreadsheets.about.com/od/excelcharts/ss/column_chart_2.htm

Something a little more advanced (EDITED - looks like KenD provided this as his answer):
http://www.techonthenet.com/excel/charts/2_y_axes.php



Edited by 1stTimeTri 2009-11-03 12:47 PM
2009-11-03 3:29 PM
in reply to: #2495498

User image

New user
110
100
Parker, TX
Subject: RE: Excel 2007 Question...NEED HELP!
Create the chart like normal, then right click on the piece of the chart you want to change... properties... axis... secondary... and the secondary one will be on the right
2009-11-03 4:00 PM
in reply to: #2495498

User image

Master
1563
10005002525
Chicago
Subject: RE: Excel 2007 Question...NEED HELP!

Thanks guys...I got it!!

You guys are the BOMB!



New Thread
Other Resources My Cup of Joe » Excel 2007 Question...NEED HELP! Rss Feed