Bar Graph with a secondary axis

[Reneek]

Hi there

I am trying to create a simple bar graph with a secondary axis.

In column A I have Supplier Names
Column B is a Dollar Value $100,000 up to $3m
Column C is an Number of Orders between 3 and 600

When I do a simple bar chart the Numbers of orders are small they cannot be seen so i put them onto a secondary axis, however they then appear on top of the dollar value bars instead of beside them.

Can anyone help?

Thanks
Renee

 

[jeffreybrown]

What version of Excel are you using?

 

[Reneek]

Excel 2010

 

[jeffreybrown]

Ok, I have 2007, but pretty sure they are the same on this.

Highlight your data >> Insert >> Charts >> Column >> 2-D Clustered Column

Select chart object

Layout >> Current Selection >> Drop down box >> Select order series (or whatever you called the second series)

Series should be hightlighted >> ctrl + 1 >> Series Options >> Plot Series On >> Secondary Axis

At this point you might want to turn that series into a line so it stands apart from the 1st series.

Click on the order series >> Design >> Type >> Change Chart Type >> select line

 

[Reneek]

Thank you - all sorted now

 

[jeffreybrown]

You're welcome and glad it worked for you

 

[secondtry]

I'm trying to accomplish the same thing as Reneek but using Excel 2003 and I can't seem to figure it out based on the steps identifiied for 2007 & 2010. Can it be done in 2003?

 

[jeffreybrown]

Here is one place to start with 2003

http://www.andypope.info/tips/tip008.htm

 

[secondtry]

Thanks for your reply jeffreybrown. Your link was helpful to follow the steps for the secondary axis. This link also helped me get the two bars for anyone else looking in the future:
http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html