Andy said:
Hi Ron,
To create a chart with values not contained within a worksheet you can
use the Source Data step of the chart wizard.
Start chart wizard, select XY scatter chart type.
At step 2 of 3 on the Series tab use the Add button.
Enter a name and for the x and y data enter numbers like this.
X Values: ={1,2,3}
Y Values: ={4,3,4}
You can the finish the chart wizard.
Note that their is a limit to the amount of information that can be
entered into a data series formula. When you select a data series its
details are displayed in the formula bar. This text can be upto 255
characters.
Is then any reason why you can not enter you values in to cells?
Cheers
Andy
Hi, Andy,
Thank you for your response, but I'm afraid I didn't express the nature
of the problem clearly enough. The problem I'm having is actually a
scaling problem. I'll be more specific: I'm working on a presentation
based on the solution of a famous Neural Network problem, known as the
Double Spiral problem.
The data set is a pattern of points that visually appears on a chart as
a double spiral, where each X-Y coordinate point in the scatter plot
defines a point on one of the spirals. There are 194 points in all, with
the data ranging from X values of -5.95 to 5.95, and Y values ranging
from -6.50 to 6.50. Call this the basic data set.
The basic data set is then subdivided into a training data set of 156
points and a test data set of 38 points, by randomly selecting points
from the basic pattern. The Chart Wizard is then used to plot all three
data sets, one after the other.
The Chart Wizard, using data values from the basic data set, then
automatically scales the basic data set plot by assigning points on the
X-axis to range from -8.00 to 8.00, and on the Y-axis to range from
-8.00 to 8.00. It scales the training data set the same way, from -8.00
to 8.00 for both the X and Y axis. So far, so good.
However, when it comes to scaling the test data set, the randomly chosen
points fall within a range of X values of -5.95 to 5.43, and Y values
from -5.25 to 5.89. Then when the Chart Wizard automatically scales the
test data set plot, it assigns points on the X-axis to range from -8.00
to 6.00, and on the Y-axis to range from -6.00 to 8.00. Consequently,
the plotted points are visually expanded from the way they would appear
if they were scaled the same way as the basic data plot and the training
data plot.
This is not good, because I want to make transparencies of all three
plots, and then overlay the training data plot with the test data plot,
in the presentation, to show how the combination of the two plots makes
up the basic data plot. If, at some point in the operation of the Chart
Wizard, I could simply define the scaling factors for the test data set,
my problem would be solved, but there seems to be no way to do this.
I hope this clarifies the problem, and that there is some simple
solution that will enable me to chart the data satisfactorily.
Regards, Ron Barry.
