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?