|
How do I assign a bar to the right axis?
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? |
How do I assign a bar to the right axis?
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? |
How do I assign a bar to the right axis?
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" 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? |
How do I assign a bar to the right axis?
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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Mike Row Soft" wrote in message ... 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" 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? |
How do I assign a bar to the right axis?
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? |
How do I assign a bar to the right axis?
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? |
How do I assign a bar to the right axis?
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? |
How do I assign a bar to the right axis?
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? |
How do I assign a bar to the right axis?
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? |
How do I assign a bar to the right axis?
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? |
| All times are GMT +1. The time now is 01:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com