secondary axis
 

I am trying to graph 4 series of data. 3 series are scatter plots and are
working fine no matter what i do. The other is a bar graph for rainfall data
(in). I want to put it on a secondary axis. I am taking a large set of data
and looking at only a few days in my range. When I change this series to a
bar graph it no longer corresponds to the range selected on the xaxis but
shows all the data available. When I put data on the secondary axis as a bar
graph, again it does not correspond with the xaxis. How can I make this work?

Here's what I did. I made the chart with four scatter series, and didn't
set any axis min/max yet. I selected the fourth and made it a column
type. Then I formatted each of the scatter series to plot on the
secondary axis. Excel now decides to make the X axis into a time scale
axis. You can double click this and set min and max, and the column
chart will obey (so will the scatters).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


tinyred wrote:

I am trying to graph 4 series of data. 3 series are scatter plots and are
working fine no matter what i do. The other is a bar graph for rainfall data
(in). I want to put it on a secondary axis. I am taking a large set of data
and looking at only a few days in my range. When I change this series to a
bar graph it no longer corresponds to the range selected on the xaxis but
shows all the data available. When I put data on the secondary axis as a bar
graph, again it does not correspond with the xaxis. How can I make this work?

Unfortunately. This doesn't work for me. When I switch the bar graph over to
the secondary axis the other series (flow data) and the bar graph again no
longer have the same corresponding xvalues (dates). I solved the problem
inelegantly by creating a second x-axis to correspond to the bar graph and
setting both x-axis ranges equal before hiding the 2nd xaxis. Because of all
the manipulation and a possibility of someone else having to revisit these
graphs the solution is certainly not ideal. Any suggestions?

Also, how do you make the secondary y-axis max occur at a height lower than
the primary y-axis?

"Jon Peltier" wrote:

Here's what I did. I made the chart with four scatter series, and didn't
set any axis min/max yet. I selected the fourth and made it a column
type. Then I formatted each of the scatter series to plot on the
secondary axis. Excel now decides to make the X axis into a time scale
axis. You can double click this and set min and max, and the column
chart will obey (so will the scatters).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


tinyred wrote:

I am trying to graph 4 series of data. 3 series are scatter plots and are
working fine no matter what i do. The other is a bar graph for rainfall data
(in). I want to put it on a secondary axis. I am taking a large set of data
and looking at only a few days in my range. When I change this series to a
bar graph it no longer corresponds to the range selected on the xaxis but
shows all the data available. When I put data on the secondary axis as a bar
graph, again it does not correspond with the xaxis. How can I make this work?

When I switched the column series to the secondary axis, I ran into
difficulties making the secondary axes visible, and I found it easier to
keep the column series on the primary axis and switch the others to the
secondary axis. The X values (dates) worked out fine with my sample
data, using only a single X axis.

One scales secondary and primary axes the same way, by double clicking
and changing the parameters in the Scale tab.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


tinyred wrote:
Unfortunately. This doesn't work for me. When I switch the bar graph over to
the secondary axis the other series (flow data) and the bar graph again no
longer have the same corresponding xvalues (dates). I solved the problem
inelegantly by creating a second x-axis to correspond to the bar graph and
setting both x-axis ranges equal before hiding the 2nd xaxis. Because of all
the manipulation and a possibility of someone else having to revisit these
graphs the solution is certainly not ideal. Any suggestions?

Also, how do you make the secondary y-axis max occur at a height lower than
the primary y-axis?

"Jon Peltier" wrote:


Here's what I did. I made the chart with four scatter series, and didn't
set any axis min/max yet. I selected the fourth and made it a column
type. Then I formatted each of the scatter series to plot on the
secondary axis. Excel now decides to make the X axis into a time scale
axis. You can double click this and set min and max, and the column
chart will obey (so will the scatters).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


tinyred wrote:


I am trying to graph 4 series of data. 3 series are scatter plots and are
working fine no matter what i do. The other is a bar graph for rainfall data
(in). I want to put it on a secondary axis. I am taking a large set of data
and looking at only a few days in my range. When I change this series to a
bar graph it no longer corresponds to the range selected on the xaxis but
shows all the data available. When I put data on the secondary axis as a bar
graph, again it does not correspond with the xaxis. How can I make this work?