A scatter plot with a 2 column data source

Hi,

I am using the Series tab (i have done a scatter plot) - i have put in 1
series of X and Y data. then i extended the "x values" data to include two
columns of data. the scale is now different and my graph is in 2D still, i
am wondering what relationship is now being described by my scatter plot.

Thanks

Excel doesn't know how to interpret your two-column X values, so it uses the
values it always does when this happens: 1, 2, 3, etc. Excel uses these
counting numbers if the X values consist of text (even a single text value
in the range), or if no X values are even specified.

If you want to add X values to a single series, put them at the end of the
original range of X values.

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


"SamB" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I am using the Series tab (i have done a scatter plot) - i have put in 1
> series of X and Y data. then i extended the "x values" data to include
> two
> columns of data. the scale is now different and my graph is in 2D still,
> i
> am wondering what relationship is now being described by my scatter plot.
>
> Thanks

thanks Jon. I ended up working this out when i knocked up a new set of
values with an obvious relationship and the plot was linear.

"Jon Peltier" wrote:

> Excel doesn't know how to interpret your two-column X values, so it uses the
> values it always does when this happens: 1, 2, 3, etc. Excel uses these
> counting numbers if the X values consist of text (even a single text value
> in the range), or if no X values are even specified.
>
> If you want to add X values to a single series, put them at the end of the
> original range of X values.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
>
> "SamB" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> >
> > I am using the Series tab (i have done a scatter plot) - i have put in 1
> > series of X and Y data. then i extended the "x values" data to include
> > two
> > columns of data. the scale is now different and my graph is in 2D still,
> > i
> > am wondering what relationship is now being described by my scatter plot.
> >
> > Thanks
>
>
>