how to create a 2 y-axis bar chart in excel

I am trying to create a bar chart in excel that has two data sets and
two y-axis
ie.
data set 1 :
1,2,3,4,5,6,7,8,9
data set 2:
100, 200, 300, 400, 500, 600, 700, 800, 900

If I do this on a normal bar chart, you would not see data set 1, so I
need to do this on a bar chart with two Y-axis. However I cannot see
how to do it with a bar for each data set. I can do it with a line and
bar.

Can anyone let me know how to do this?

Regards

Rod


---
Message posted from http://www.ExcelForum.com/

Right click on the data series in the chart
From popup menu select Format Data Series
Open the Axis tab
Click in the Secondary y-axis box
Done

Best wishes

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address


"reallyf " wrote in message
...
I am trying to create a bar chart in excel that has two data sets and
two y-axis
ie.
data set 1 :
1,2,3,4,5,6,7,8,9
data set 2:
100, 200, 300, 400, 500, 600, 700, 800, 900

If I do this on a normal bar chart, you would not see data set 1, so I
need to do this on a bar chart with two Y-axis. However I cannot see
how to do it with a bar for each data set. I can do it with a line and
bar.

Can anyone let me know how to do this?

Regards

Rod


---
Message posted from http://www.ExcelForum.com/