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.
 

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.

dave3009

Well-known Member
Joined
Jun 23, 2006
Messages
7,002
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.
 

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.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,163
Messages
5,509,540
Members
408,739
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...
Top