Two vertical axes - is it possible to have?


New Member
Sep 22, 2009
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.

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.


Well-known Member
Jun 23, 2006
Office Version
365, 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.


New Member
Jun 22, 2010
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.

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Latest member
Forre_Learning Excel

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...