I am tyring to make a graph that has 2 y-axis'. I know how to do this but the problem is once i make a 2nd y axis my chart changes to single columns. I need it to be a bar graph with 2 bars for each item on the x-axis for comparison reasons. I have attached an example of what i'm doing.
The first chart in the example is what i need it to look like but with a 2nd y axis. The second chart is what happens when i add a 2nd y axis.
Last edited by Analyst13; 08-29-2011 at 08:48 AM.
I guess everyone is as stumped as I am. However i was able to manipulate it somewhat. Can I get opinions on how anybody thinks this looks?
You have to alter you data layout
http://peltiertech.com/Excel/Charts/...OnTwoAxes.html
Does anyone have an idea how to solve the similar situation in Excel 2007. Thanks!
It works the same way in 2007 as in 2003.
Jon Peltier
http://PeltierTech.com/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks