Bar graph with two different scalas on the Y-axis

[chilly_bang]

I have a table with two data columns: the first column contains naming values, the second column contains values from 0 to 1, the third - values from 1.000 to 100.000. I want to display them on the same (bar) graph.

I've seen such graphs, where on the X axis are naming values (from column A), the Y axis has two scalas: on the right, say, 0 to 1, on the left like 1.000 to 100.000, so values from different columns are displayed not in the same scala, because the first will be nearly unvisible.

I assume i need this graph type, but i can't find, how to do it in Excel. Could somebody point me to?

 

[ekrause]

You're looking to add a secondary axis.

Right-click on one point of the series, choose "Format Data Series", in the dialog click on the tab "Axis", and check "Plot Series on Secondary Axis". - take from previous MrExcel Poster.

You should be able to figure it out with a google search about secondary axis and Excel.