Thread: Scatter plot and line graph combination

Hi

I need to create a scatter plot of three ranges of data and then have three
lines for three different ranges. Is this possible?

I need to depict three classes of item and straight lines that separate
them. The items are plotted on the graph using a scatterplot as three
separate ranges. The lines (which represent mathematical functions) are to
be plotted as line graphs.

This is to depict a neural network classification problem.

I have tried editing the custom types by taking a copy of one that is
similar and then trying to modify it. Unfortulately only one of the ranges
has X and Y data ranges (which are needed for the plot) and the others have
just one axis (which is fine for the lines).

If anyone knows what I am trying to say, and has any ideas then please let
me know - I would be grateful

Cheers in advance

Tim

Tim -

Couldn't you just use scatter chart series for all of the data? Format
the "line" series to have a line with or without markers, and the
"scatter" series to have just markers.

The distinction between line and scatter charts has nothing to do with
whether the chart has markers only or lines connecting the data. Rather
it refers to the treatment of the category axis.

I've written a couple of articles which may help to explain the distinction:

http://peltiertech.com/Excel/ChartsH...ValueAxis.html
http://pubs.logicalexpressions.com/P...cle.asp?ID=190

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


Tim Gilderseeve wrote:

> Hi
>
> I need to create a scatter plot of three ranges of data and then have three
> lines for three different ranges. Is this possible?
>
> I need to depict three classes of item and straight lines that separate
> them. The items are plotted on the graph using a scatterplot as three
> separate ranges. The lines (which represent mathematical functions) are to
> be plotted as line graphs.
>
> This is to depict a neural network classification problem.
>
> I have tried editing the custom types by taking a copy of one that is
> similar and then trying to modify it. Unfortulately only one of the ranges
> has X and Y data ranges (which are needed for the plot) and the others have
> just one axis (which is fine for the lines).
>
> If anyone knows what I am trying to say, and has any ideas then please let
> me know - I would be grateful
>
> Cheers in advance
>
> Tim

Thanks Jon

Thats done it. I hadn't thought of that because of the difference in the
data. However, it seems to be ok.

I have used Excel for years, but only now and again and my charting skills
are very rusty.

Thanks again.

Tim

Jon Peltier <jonREMOVExlmvp@peltierCAPStech.com> wrote in
news:#BbJ5JkbFHA.3404@TK2MSFTNGP10.phx.gbl:

> Tim -
>
> Couldn't you just use scatter chart series for all of the data? Format
> the "line" series to have a line with or without markers, and the
> "scatter" series to have just markers.
>
> The distinction between line and scatter charts has nothing to do with
> whether the chart has markers only or lines connecting the data.
> Rather it refers to the treatment of the category axis.
>
> I've written a couple of articles which may help to explain the
> distinction:
>
> http://peltiertech.com/Excel/ChartsH...ValueAxis.html
> http://pubs.logicalexpressions.com/P...cle.asp?ID=190
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
>
> Tim Gilderseeve wrote:
>
>> Hi
>>
>> I need to create a scatter plot of three ranges of data and then have
>> three lines for three different ranges. Is this possible?
>>
>> I need to depict three classes of item and straight lines that
>> separate them. The items are plotted on the graph using a
>> scatterplot as three separate ranges. The lines (which represent
>> mathematical functions) are to be plotted as line graphs.
>>
>> This is to depict a neural network classification problem.
>>
>> I have tried editing the custom types by taking a copy of one that is
>> similar and then trying to modify it. Unfortulately only one of the
>> ranges has X and Y data ranges (which are needed for the plot) and
>> the others have just one axis (which is fine for the lines).
>>
>> If anyone knows what I am trying to say, and has any ideas then
>> please let me know - I would be grateful
>>
>> Cheers in advance
>>
>> Tim
>