Hi,

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:

http://www.peltiertech.com/Excel/Cha...tiaryAxis.html

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?

Thanks,

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:

http://www.peltiertech.com/Excel/Cha...tiaryAxis.html

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?

Thanks,

- How do I add a second axis to a graph with 2 data series?
- Add another y axis to graph
- How can i add a secondary y-axis to a bar chart (not a line chart)
- Adding a secondary Axis to a graph
- Excel Chart How do I create Y axis to represent numbers I am using
- Dates on Dual Y-Axis Line charts
- Y Axis and line graphs
- Double-stacked Bar Chart WITH a Secondary Y Axis Line chart?
- How do I create a double y axis BAR CHART (not bar + line)?
- How do I make two y axis in bar graphs (i.e. cross hatching)??
- VBA: add a series of data (Y secondary axis) to existing graph
- Bar Graph with Double y-axis
- Putiing a 2nd y axis on a column chart
- Set Chart/Graph Minimum/Maximum Scale To Nth Smallest & Largest Value
- Dynamic Graph/Chart With Changing Y-Axis Via Combo Box
- Need Help With Sizing/Formatting X-Y axis on Graphs
- Excel Chart - how to increase the height of the y-axis.
- How to switch the primary and secondary Y axis to opposite chart s
- "broken" y-axis in Excel charts
- Is there a way to offset the y-axis of a chart without having the.
- Changing decimal place of y-axis in chart with vba
- Putting to different range values on y-axis of a chart
- Strange chart problem - Y axis scaling
- "broken" y-axis in Excel charts

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.

Thx

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

missing.

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

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.

Krefty

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.

Paul

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?

I've read and understand the "Column Chart with a Difference" example he

http://people.stfx.ca/bliengme/ExcelTips/Columns.htm. But, need to go the

step further, to have a % displayed on the secondary Y axis.

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.

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.

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,

Jason

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:

VB: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.ActiveChart.Axes(xlValue).Select With ActiveChart.Axes(xlValue) .MinimumScale = Range("Min").Value .MaximumScale = Range("Max").Value End WithIf you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

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.

Thanks

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.

TIA.

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.

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.

Mike

--

burnsbyrne

------------------------------------------------------------------------

burnsbyrne's Profile: http://www.excelforum.com/member.php...o&userid=22153

View this thread: http://www.excelforum.com/showthread...hreadid=536427

to the right a little, but does not want anything to the left of it. Is

there a way to do this in Excel?

Thanks

Jonathan

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

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

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?

~Shiv

(Excel 2003 SP2)

Mike

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