How do I assign a bar to the right axis?

[Mike Row Soft]

I have a bar chart with three colums. The left column is dollars. I want to
make the right column percentages and assign the right column to the right
axis? How do I do this?

 

[Andy Pope]

Hi,

You need to create 2 series and move one of them to the secondary axis.
http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

Cheers
Andy

 

[Mike Row Soft]

Thanks, but that is much more complicated (12 columns) than what I am doing.
I just have 3 columns, 2 on the left I want in dollars and 1 on the right I
want in percentage. Is there a simple way to do this?

 

[Andy Pope]

Hi,

You can not place individual points of a series on another axis. You need to
add another series with the values you want on the other axis.
Once you have separate series you can select which axis to use. The problem
is if you have 2 column series on different axes then they will overlap each
other.

Or maybe I'm not understanding your explanation of what data you actually
have.

Cheers
Andy

 

[Mike Row Soft]

Here's what I want:

Left axis: dollars
1st column: $80,000
2d column: $900,000

Right axis: percentage
3d column 62%

 

[Andy Pope]

Assuming you data is currently in A1:A3

£80,000.00
£900,000.00
62%

Change it to be in A1:B3

£80,000.00 <empty>
£900,000.00 <empty>
<empty> 62%

Now create your chart so it has 2 series.
Select the second series and move it to the secondary axis.

Cheers
Andy

 

[Mike Row Soft]

I forgot to mention my bottom axis: 80,000 is Operating Profit, 90,000 is Net
Profit, 62% is recoupment. Which cells do I put these in?

 

[Andy Pope]

If you insert a new column A you can place the category labels in A1:A3.

So now your chart information is in A1:C3

Cheers
Andy

 

[Mike Row Soft]

How do I "Now create your chart so it has 2 series. Select the second series
and move it to the secondary axis"? Please tell me exactly what to write in
which dialog box. I guessed at this, and the 3d column ended up stuck next
to the 1st, with no Recoupment in the bottom axis. Thanks!

 

[Andy Pope]

You can not do combination charts with the 3d types.

I forgot to mention my bottom axis: 80,000 is Operating Profit, 90,000 is
Net
Profit, 62% is recoupment. Which cells do I put these in?

A1: =Operating Profit B1: =£80,000.00 C1: =<empty>
A2: =Net Profit B2: =£900,000.00 C2: =<empty>
A3: =Recoupment B3:= <empty> C3: =62%

Cheers
Andy