Two vertical axes - is it possible to have?

Fernesto

New Member
Joined
Sep 22, 2009
Messages
2
I would like my bar chart to have two vertical axes. The left one for values and the right one for percentages with horizontal lines connecting the values on the left with the percentages on the right. I managed to draw and label a right axis on my chart (the line with a shape and the percentages in text boxes) but it was time consuming and I need to do many charts.

Ideally, I would make my double vertical axes chart a template. I tried to make my creation a template but the resulting template wasn't accurate. (I know I can easily label the bars with percentages but that isn't what I was tasked to do!)

Thanks for any suggestions.
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

dave3009

Well-known Member
Joined
Jun 23, 2006
Messages
7,003
Office Version
  1. 365
  2. 2016
Hi and welcome

You can plot one of the ranges to a secondary axis, in Excel 2007 you just right click and choose option, then click secondary axis. Can't remember how it's done on previous version but you could tinker about.
 

Fernesto48

New Member
Joined
Jun 22, 2010
Messages
7
My problem isn't solved after all. I followed the directions and created a second Y axis but cannot figure out how to format the gridlines on the right Y axis to be percentages.
 

Watch MrExcel Video

Forum statistics

Threads
1,133,720
Messages
5,660,511
Members
418,581
Latest member
gtarr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top