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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Mike Row Soft" wrote in message
...
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" wrote:

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Mike Row Soft" wrote in message
...
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" wrote:

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
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Mike Row Soft" wrote in
message
...
Here's what I want:

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

Right axis: percentage
3d column 62%

"Andy Pope" wrote:

Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Mike Row Soft" wrote in
message
...
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?