Free Microsoft Excel 2013 Quick Reference

Add Tertiary Y Axis To Chart/Graph


I am looking to add a tertiary Y-axis to my chart. I was searching through the internet and came across Jon Peltier's page:

However, I think he nomore has the process of adding a tertiary axis on the page. It would be nice if someone could point to the resource if it is available anywhere else. Any other pointers would also be appreciated.

Also would it be possible to hide the markers and the labels of the tertiary axis?


Post your answer or comment

comments powered by Disqus
I am creating a graph in Excel 2002 with 2 data series (bone mets and no bone
mets). I need to add a second y-axis to the graph, but when I follow the
excel Help directions, it removes one of my data series from the graph (ie,
it can no longer be viewed).


I've got a line graph that shows two trends, both trends break go thru the x axis. I'd like to add another scale on the right hand side for y axis, but don't know how to do this within Excel.

Any ideas much appreciated.


I can't seem to get two data series to plot on two different y-axis when
using vertical bar chart format. If I get the Y-axis to display I only get
one series of data displayed, although the scales of the y-axis are correct
for each data series. The second data series seems to be under the first when
displayed this way, but playing with the option tab settings under format
doesn't bring them out on their own!

I am having trouble adding a secondary axis to a graph.
I am follwoing Excels' built-in Help and that shown Section 4.6 Using
Multiple Axes of David Bourg's book, "Excel Scientific and Engineering
Cookbook", but the instructions either aren't clear enough or soemthing is

Here is Microsoft's built-in Help along with my commnets after each step.

1) On a chart sheet (chart sheet: A sheet in a workbook that contains only a
chart. A chart sheet is beneficial when you want to view a chart or a
PivotChart report separately from worksheet data or a PivotTable report.) or
in an embedded chart (embedded chart: A chart that is placed on a worksheet
rather than on a separate chart sheet. Embedded charts are beneficial when
you want to view or print a chart or a PivotChart report with its source data
or other information in a worksheet.), click the data series that you want to
plot along a secondary value axis.

I have an x-y graph on the right-hand-side of my Excel spreadsheet.
How do I select a series ? Clicking & Dragging over the column of data
that I want along the secondary axis does not yield me what is involved
in Step 2....I do not get the menu selection needed in Step 2.

2) On the Format menu, click Selected Data Series.

I do not find the selection (Selected Data Series) under the spreadsheet's
Format menu. Thus, I cannot perfrom Step 3.

3) On the Axis tab, click Secondary axis.

Any ideas ?

Thank you...DaleB

I am attempting to create a chart that is populating its data from another
worksheet in the same book. I am pulling in numbers that range from 75000 to
3000000 and I would like my y axis to be 50K to 350K in multiples of 25K but
I can not figure out how to adjust the axis key.

Thanks for your help in advance.


Please help.

I have played with this but unable to get it to work.

I have dual y-axis line charts:
-Data on J and K columns
-Date on A column
-The other columns in between are criteria for autofiltering.

I currently see series on numbers (same as the row counts) on the X-axis like from 0 to 4000 but I want to label these data points by date from column A.

I think the problem is the 'Secondary (X) Axis labels is greyed out from the popup Data Source -> Series tab. (this window pops up when right click on the chart and select 'Source Data'.

Why is this box greyed out? I think this is where I need to inclue the link to column A for the date to show up on the X axis.

Thanks in advance for the reply.

I have two questions both regarding the 'y' axis on a line graph
Firstly how do i get the 'y' axis to appear at the center of the graph IE at
(0,0) and not (-10,0) as it is currentley on my graph
Secondly how would i plot the line X = 3 which should just be a straight line

An unrelated question but is it possible to graph functions in excel? right
now i just put the x values in one column and calculate the y values in
another and copy the formula down - is there a quicker way?

How can I create a double stacked bar chart w/ a secondary Y-axis line chart?
I've read and understand the "Column Chart with a Difference" example he But, need to go the
step further, to have a % displayed on the secondary Y axis.

How do I create a double y axis BAR CHART (not bar + line)?

Hi all,
I'm stuck at this step.

I have a serial of data (sheet1: cell A4:A20). I would like to add this series to one of 3 existing graphs(ch1, ch2, ch3) using the Combobox drop down list to pick.

the X axis of the existing graph will stay the same. The Y axis will be secondary Y axis(A4:A20)

How can i do this with VBA? A quick reference is much appreciated.

I am tyring to make a graph that has 2 y-axis'. I know how to do this but the problem is once i make a 2nd y axis my chart changes to single columns. I need it to be a bar graph with 2 bars for each item on the x-axis for comparison reasons. I have attached an example of what i'm doing.

The first chart in the example is what i need it to look like but with a 2nd y axis. The second chart is what happens when i add a 2nd y axis.

Hi All,

How I go about setting a 2nd y axis on a column chart? I know the default is 1 y axis.

But say I've got 2 data series, and the 2nd data series is in a much smaller unit than the 1st. So I'd like the 2nd y axis to be scaled to the 2nd data series so I don't get distorted graphs with the 2nd data series being miniscule compared to the 1st.

Please Help!

With Thanks,


I am trying to manually format a few graphs in my sheet. I, however, leave the major units of the axes to be automatically calculated. The code that I use is given below:

With ActiveChart.Axes(xlValue) 
    .MinimumScale = Range("Min").Value 
    .MaximumScale = Range("Max").Value 
End With 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Now what this does is that it sets the maximum of the scale exactly equal to maximum of the range being plotted and hence a few parts of my graph overlap with the border of the plot area.

Is there any way in which I can round the max and min scale of y-axis to the next highest and lowest major unit respectively or may be add and subtract a value proportional to the major unit of the y-axis

I cannot add a constant in the code given above since I that does not suite my requirements.

Thanks a lot.

I need to graph different properties all versus time, I was wondering if you were able to create a combo box to simply change the y axis on the graph. I will attach the data sheet.

I am taking an online statistics course. We are doing charts/line praphs now. The standard is that the X axis has to be 75% as long as the Y axis when the graph is printed. I cannot find a way to size the axis when I am doing the graph so that it comes out that way each time. When completed in default the X axis is always shorter so it is difficult to determine the sizing (by trial and error I am keeping the ink cartridge companies in good business )..
thank you for any help on this matter

I am not familiar with charts. Recently I created a line chart and I wanted to change the y-axis...

Excel built the y axis to cover values from 0 to 4,000 but the line were too closely placed and I was hoping I could spread out the values more .... increase the relative height of the y-axis - but how?

Thanks...not urgent. Just an exploration of something new. As I write, I think I can take out one of the lines which is in the 3,500 range and cut some off the top.


Using Excel 2007, evertyime I refresh pivot table data, my charts lose almost
all of the formatting (ex. axis will disappear and chart type will revert
from lines to columns).
Most annoying problem I have when this happens is the primary Y axis moves
from the left side to the right side of the chart, and when I re-introduce
the secondary Y axis, it will appear on the left. How can I easily move the
primary Y axis back to the left side of the chart or switch the two axes?
I've tried choosing Layout - Axes to hide and re-display the axes but this
did not work.

I often need to graph two parameters on the same bar graph whose high
values differ by a great deal - sometimes by a factor of 10 or 20 -
which makes the lower values almost disappear. I could use a second y
axis but sometimes it's inconvenient to do so. I have seen charts in
scientific journals that "break" the y-axis to indicate that the scale
has been compressed and partially hidden. Is this possible in Excel?
It would really come in handy sometimes.


burnsbyrne's Profile:
View this thread:

I'm making a xy scatter graph for my boss. She wants me to offset the y-axis
to the right a little, but does not want anything to the left of it. Is
there a way to do this in Excel?

I have a macro that creates charts for alot of people. I cant seem to figure out how to change the decimal placing of the y-axis in vba. Right now it is at 2 decimal places (which is the default) and I dont want it to show any decimal places, just the whole number. Does anyone kow the code that will allow me to do this? The code for my macro is below. Any help would be appreciated.


Sub Chart()

Dim i As Long
Dim n As Long
Dim wsh As Worksheet
Dim cho As ChartObject
Dim cht As Chart
Set wsh = Worksheets("Emp Data")
n = wsh.Range("A65536").End(xlUp).Row
For i = 2 To n
Set cho = wsh.ChartObjects.Add(Top:=160 * i - 310, Left:=10, _
Height:=150, Width:=300)
Set cht = cho.Chart
cht.ChartType = xlColumnClustered
cht.SeriesCollection.Add Source:=wsh.Range("F" & i)
cht.SeriesCollection.Add Source:=wsh.Range("N" & i)
cht.SeriesCollection.Add Source:=wsh.Range("P" & i)
cht.SeriesCollection(1).Name = "taint"
cht.SeriesCollection(2).Name = "4%"
cht.SeriesCollection(3).Name = "bump it"
cht.HasAxis(xlCategory) = False
cht.ApplyDataLabels (xlDataLabelsShowValue)

Next i
End Sub

hi All,

i am looking for some help here. i have a chart which i want to put 2 ranges on the y-axis to display the information as in 10's and 100's
could some one please advise?

thank you

Hi all!

Ok I'm generally pretty good with excel but this one has me stumped! I have two charts each with two series. The lowest datapoint on the first chart is 280, and on the second it's 353. The strange thing is, altho they are both set to fully automatic scaling of the Y axis the first graph looks right and the axis crosses at 250, the second graph crosses at 0!

I've attached a sample spreadsheet to show what I mean. Does anyone know why this might be happening and if there's a way to have the min value on the Y axis of the second graph cross at a more sensible place without having to set the options manually?

(Excel 2003 SP2)

I often need to graph two parameters on the same bar graph whose high values differ by a great deal - sometimes by a factor of 10 or 20 - which makes the lower values almost disappear. I could use a second y axis but sometimes it's inconvenient to do so. I have seen charts in scientific journals that "break" the y-axis to indicate that the scale has been compressed and partially hidden. Is this possible in Excel? It would really come in handy sometimes.

No luck finding an answer? You could always try Google.