Email:      Pass:    Pass?
Close Window   
TE
Subscribe for Email Updates!
Excel tips, help, and more!
E-mail:


Advertisements


Free Excel Forum

Multiple Axes

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Hi!

Is it possible to have more than one secondary axis? I have several data series that I want to show in one chart, but I've only figured out how to do ONE secondary axis. I know I've seen charts with a bunch of axes on each side, can't you do that in Excel?

Thanx!
/s

View Answers     

Similar Excel Video Tutorials

Helpful Excel Macros

Delete All Chart Sheets in Excel - Only Chart Sheets are Deleted - Not Embedded Charts
- Delete all chart sheets and tabs in Excel using this macro. This will only delete the charts and graphs that are in the
Get Values from a Chart
- This macro will pull the values from a chart in excel and list those values on another spreadsheet. This will get the s
Print all Embedded Charts in the Entire Workbook
- This macro will print every embedded chart in the active workbook. If you have an embedded chart in any worksheet within
Create a Line Chart with a Macro in Excel
- Create a line chart in Excel with this macro. This allows you to quickly and easily create line charts and graphs from
Print All Charts That are in a Worksheet
- This macro will print all of the embedded charts which are on the current active worksheet. Each chart will be printed o

Similar Topics







Hi!

Is it possible to have more than one secondary axis? I have several data series that I want to show in one chart, but I've only figured out how to do ONE secondary axis. I know I've seen charts with a bunch of axes on each side, can't you do that in Excel?

Thanx!
/s


i have one set of data (keep in mind i am a novice). the x and y axes have tic marks. i am trying to add tic marks to the secondary axes and when i go to the pulldown and dialogue box where the secondary axes information should appear - there is nothing, not even a grayed out box.

the method i use is to click on either the secondary x or y axis and then go to the format menu - there is no secondary axis. what am i doing wrong?

i would appreciate any assistance
thanks very much


I've been viewing the forum for Secondary axis in 2007. I imported a 2003 file with multiple series and do not see the right side axis. In 2003, under chart area/chart options/axes, you could add a secondary axis for value only. This allowed right side axis information that you would line up with the left side primary axis for viewing only.

I notice from the forum and playing with 2007, that this is no longer available and one must now plot a series to a secondary axis to be able to see a scale (either using a dummy series or a real one, then adjust the new axis to be the same as the primary)....How do we get this back.

My problem, is that when I select an existing series and re-plot on the secondary axis, the series compresses to the left side of the graph. The vertical looks fine, but the horizontal is shrunk. When I select the series, I see that the ranges in the series (in the formula bar) do extend to the full end of the graph (the same as other primary curves). Could there be something wrong with my series. I have also tried to delete and recreate the series (using the select data icon and adding a new series, then modify and plot on a secondary axis, ...same shrunk curve.

Does saving the file in the old format of Excel retain the old functions, or do you just loose some unsupported functions?


Hello
I have two sets of data that need to be plotted, as a bar chart, on the same x-axis but with a different y-axis (one for volume of people and one for total hours worked per month).
I obviously need a secondary axis for this but when I go Format Data Series>Axis>Secondary Axis, although the secondary axis appears on the right as it should do, the data stacks itself so that I have series 1 on top of series 2.
Does anyone know how I can put the data side-by-side with series 1 referencing the left axis and series 2 referencing the right axis?
Thanks

Tom


I feel that this shouldn't be difficult, but I'm flummoxed!

My colleague is trying to chart two data series with commission on the y axis and margin on the x axis. For series 1, the margin goes from about -1.5% to about -6%. For series 2 the margin goes from about -1.8% to -7%. He wants both series on the same chart.

I tried adding a secondary x-axis - but both x axes are category axes, so I can't change the scale so they match.

I tried adding a secondary y-axis (as that allowed me two sets of x-axis labels), but although the RHS of the lines looked right, the LHS of both started in the same place.

What am I missing?


Hello,

Sometimes, I like to plot *ONE* set of line chart data along both the primary and secondary vertical axes. This is done as a visual aid (so the reader may follow a data to either the left or right, depending on which side of the chart the data is closest to). However, the problem is excel sometimes does not automatically set the same MAX/MIN values for both the primary and secondary vertical axes, resulting in appearance of *TWO* separate line charts at different 'heights' along the Y axis. Is this a bug? Am I missing something as, ideally, I want the same MAX/MIN values for both the primary and secondary vertical axes to be autoselected. Note I am aware of manually overriding these settings, but my these particular charts are templates used for wide ranges of data, so manually overriding is not preferred.

VLG


I am trying to create a graph with two y-axes, whereby on the secondary y-axis I want it to cross at y=0, so that this will plot chart data above and below the x-axis. Currently I can only get this secondary y-axis to cross the x-axis at its lowest point which is -1 (the range being -1 to 1). Could anybody please offer any suggestions?
Thanks in advance.


I have a bunch of charts that I need to plot voltage and current measurments on primay and secondary axis respectivly.

Is there anyway to do this when I create the chart? Each chart will have four different series on the primary axis and eight on the secondary.

The problem I have is when creating the chart everything gets put on the primary axis. when I select a data set and place it on the secondary axis Excel automatically adds markers to the line. Now I have to go it and remove the markers.

This just creates more work for me.

Is there any way to place a data set on the secondary axis without Excel adding markers or doing anything else I did not ask for?


Hi The

I'm trying to plot 3 data series on a chart with two vertical axes and one horizontal axis. All three data sets correspond to the same dates and times (so I want one horizontal axis), but the series on the secondary axis (the column chart) is offset from the other two (xy scatter with straight lines). If I try to view the secondary horizontal axis, it perminently alters the column chart. No matter what, I can't get the horizontal axis of the column chart to align with the xy scatters. Any suggestions on how to accomplish this?

Thanks for your help!!


I have a bar graph with two value axes. Scale of the primary axis is 0 to 25; scale of the secondary is -1 to 8. The category axis crosses the primary y-axis at 0, but the secondary at -1 (with the result that the bars with a positive value seem to start in mid-air above the x-axis).

If I look at Format Axis, Scale, there is a tick in the box which says "Category Axis crosses at ...", and a value of zero in the field next to it. (This is the case for both y-axes.)

Any advice how to "shift", so to speak, the secondary y-axis to cross the x at y=0?

Thanks in advance!



(Is it possible to insert a screen dump of the graph here to illustrate what I'm talking about?)


I am trying to understand how secondary axis's work. And I have the concept down and have created a secondary axis.

(See attachment) My data points are all junk and I just put them there to get something on the chart.

My goal: I want the secondary X axis to not be as tall as the primary.

So if the primary has 1-10. I want the secondary to only be labeled to the 0-1. I want the secondary axis to be shorter than the primary. Seems like no matter what I do, it auto formats to expand to the top. I want there to be a bunch of space between the max secondary x axis max and the top of the chart. So the primary X will go from floor to roof of the chart, and the secondary will go from floor to 1 unit, and far from the roof.


Making transition to 2007 and going through learning curve. Searched forums but too many secondary y-axis threads.

I have 2 series on a bar graph, one on each y-axis with a common time scale on X axis. That part is done. But as soon as i enable the secondary Y-axis, the bars stack infront of each other and i want them side by side as they were before enabling secondary y-axis.

Help
Schwizer


The help screen lies! That's a heck of a way to start this question.
Ok, I might be wrong, but I've checked SEVERAL times and can't get to what i need.


The help screen says:

You can plot data on a secondary vertical axis one data series at a time. To plot more than one data series on the secondary vertical axis, repeat this procedure for each data series that you want to display on the secondary vertical axis.

1.In a chart, click the data series that you want to plot on a secondary vertical axis, or do the following to select the data series from a list of chart elements:
1.Click the chart.
This displays the Chart Tools, adding the Design, Layout, and Format tabs.

2.On the Format tab, in the Current Selection group, click the arrow in the Chart Elements box, and then click the data series that you want to plot along a secondary vertical axis.


2.On the Format tab, in the Current Selection group, click Format Selection.
The Format Data Series dialog box is displayed.

Note If a different dialog box is displayed, repeat step 1 and make sure that you select a data series in the chart.

3.On the Series Options tab, under Plot Series On, click Secondary Axis and then click Close.A secondary vertical axis is displayed in the chart.



Ain't no Plot Series On, I see the Series Option, but there is no Secondary Axis.

All help is greatly appreciated.
Thanks, Phil


Hi, I have a chart of several data series which to make more clear would like to assign certain data series to a primary y-axis (vertical) and certain data series' to a secondary y-axis. When I select a certain data series and assign it to a secondary axis, the secondary axis appears as expected on the right hand side of the chart. However, the chart line of this data series then disappears i.e. the data series is no longer visible in the chart area. This is not an issue with scaling as with the same data there was no issue with excel 2003. Has anyone else encountered this problem and found a solution? Thanks in advance.


Hi,

I am using excel 2010 and on a chart have two horizontal date axes, one primary one secondary. Now the problem I am having is that although the settings on both the axes are exactly the same including the Max and Min values etc the secondary horizontal axis is two notches wider than the primary horizontal axis creating white space on both sides of the chart. I have also attached a jpeg showing the same.

Any ideas what could be causing this?

Thanks


Hello, I am making a chart that has separate scales for 2 different series of information.

So I have 4 series I want to chart as an area chart, but 2 are on a very different scale than the other two--I am using the right (secondary) y-axis for two of the series and the left (primary) y-axis for the other two.

the problem is that once i separate the series onto separate axes, i can no longer manipulate their relative series order (so that one lays on top of the other visually) under the "Series Order" Tab of the "Format Data Series menu"... I only get the option to Move Up or Move Down relative to the other series on the chart. furthermore, there doesn't seem to be any rhyme or reason to whether the primary scale series or secondary scale series goes on top, but rather that it is based on order of adding the series. does anyone know how to work with this?

thanks!


I am trying to do a chart with a secondary axis. I am using excel 2000 and I
can't find the secondary axis. I see under the axes tab only a primary
axis...any suggestions?



It's so weird. I have a chart with 2 data series, I have a secondary axis for the second series. I want the primary axis to cross horizontal at 0 and min value to be 0. The secondary axis I want to have min at - 400 and cross horizontal at 0. For some reason, when I change "Horizontal axis crosses" parameter for each of the axes, secondary axis still crosses horizontal at -400. What can possibly be wrong?? Why Excel would not change when I tell it to?

Thank you for help!


I have a simple chart that shows actual expenses with a line and budget with an area chart. I like the data to show up on the tick marks, so that it takes up the entire horizontal plot area.

When I add a secondary axis, the left side of the line and area charts stay on the tick marks, but the right side pulls off of the tick marks, leaving an unsightly gap. I have tried re-formatting the x-axis, but it doesn't help. If I remove the new series of data, the chart goes back to how I wanted it.

How can I get my charts to be flush on the right side again, with the secondary axis???


Hi there, using XL2K

I am using GetChartElement on a chart to find out which series the user has
clicked on in the legend, and I have run into a small (hopefully) stumbling
block - my chart is a clustered column chart with 2 y-axes, where series 1
and 2 are on the primary and series 3 is on the secondary.

When GetChartElement returns arg1 as the seriesindex (arg2 is presumed empty
because that's what is supposed to happen when the elementid is xlLegendKey
or xlLegendEntry, correct?), everything is okay if the series picked is one
of the two on the primary axis, but if it's series 3, then arg1 is set to
"1", not "3" as it should be, I guess because it's series 1 on the secondary
axis.

So the question that comes up, is that since Excel seems to be saying
"you've picked series 1 on the secondary axis", how do I find out whether
the user's picked series 1 on the secondary axis or the primary???


----------------------------------
Please reply to NG.





I have created a chart which has 2 data sets (stock returns). The data are from 2 different time periods of equal length, therefore I want 2 X-axes. I have created a "secondary axis" which displays a secondary Y-axis, and then I can add in a secondary X-axis. However, this secondary x-axis just diplays dates from 1/1/1900 and I cannot change this. The primary X-axis displays the range I specified under "select data". I would like to reference a second range of dates or edit the second X-axis. Please offer suggestions.

Thank you,
Erik


I've got a combination chart (line graph and scatter graph combined) with primary and secondary x and y axes.

I'd like to change the scale on both the x and y axes.

The y axes seems simple enough. I right-clicked on both the primary and secondary axes and selected "format axis" and was then able to change the scale in the pop-up menu.

The x axes are proving more problematic. I right click on the top x axis, click "format axis" and the same menu pops up as for the y axis and I can change the scale no problem.

I then right click on the bottom x axis, click "format axis" and a different menu pops up. Rather than saying "Value X Axis Scale" the menu name is "Category X Axis Scale" and there doesn't seem to be any option to change scale.

Does anyone know what I am doing wrong?


Hi,

I have a series of datapoints on a xy scatter chart. The data points extend from x=-100 to x = 100. I am trying to shade two different regions - one -100<x<0 and the other 0<x<100. I went through the many examples on the net and figured out that a scatter chart with a 'timeline' category x axis or a bar chart with a timeline category x axis works well. However, when I change the primary x axis from -0.3 to 0.3 or so, the secondary axis range still remains the same and the shading gets messed up. I have to apparently change the secondary x scales too. I tried scaling the 2 x axes by the same numbers but I am not able to set negative values as limits. Can someone help me with this. I hope I made myself clear. I have been struggling with this for a day.

Thanks a lot.

Ram


I have set up a pivot chart with 12 points and 8 or 9 data series.

Is there a way to have excel plot a series line linked to the primary axis and use another scale for that same series to a fixed value on the secondary axis? i.e. if the series line on the primary were over or close to 10,000 but that line also representing 200 or 300 on the secondary axis?

There are over 450 different page views for my pivot chart and the fixed data point will not be the same for each view, nor of course will any other data series.

Thanks for anyone who can help!!


A colleague of mine is wanting to create a column chart on 2 different axes. The y axis is months but then we need 2 separate axes and 2 separate columns for each month, one on each axis.

When we add a secondary axis, excel stacks the columns but we want to show 2 separate columns.

Any help towards this is appreciated.