Three graph into one
 

suppose I have

y=e^x [where x=0.5 to 1.5];

and after interpolation I found x ,y values

graph2--values
.............
x y
0.1 0.5
0.2 0.6
0.3 0.8
---------------
graph3--values
............
x y
0.1 0.8
0.2 0.9
0.3 0.10


Now I want Excel to plot the graph1 and graph2
with the give function y=e^x (superimposed).

Please help me .

Three graph into one
 

I had a problem where I needed three pivot charts on top of each other...similar to the end result you're looking for. What I discovered is that you can set
the Chart background (not the Plot background!) to None and move each chart on top of another so the others show through:
right click on the Chart background
select Format Chart Area...
click the None radio button located in the top right area (in the Area box)
click OK
Now if you click somewhere else on the sheet or simply tap the 'Esc' keep the focus will leave the chart you selected and you'll see it become transparent!

If you do this process with each chart you can place them on top of each other. You may need to adjust or remove axis titles and legends from the charts. If
you use the same axis then you can clear all of the charts but one (which would show). For example, the x-axis for my charts were all the same, quarter and
year, but the y-axis was different (avg. # of calls, avg. call time, & avg. revenue) so I removed all titles, y-axis and legends but on the last chart I left
the x-axis alone since it was the same for all three charts. I moved the charts on top of each other so the borders lined up and, as far as the manager was
concerned, it looked like one chart with three different plots :-) Of course, I tweaked it so the plots had different colors and I also showed the charts
grouped together (but not on top of one another) on another sheet so they could be viewed as individuals.

HTH,
Toby Erkson
Oregon, USA

On 30 Apr 2004 03:55:57 -0700, (why) wrote:

suppose I have

y=e^x [where x=0.5 to 1.5];

and after interpolation I found x ,y values

graph2--values
............
x y
0.1 0.5
0.2 0.6
0.3 0.8
---------------
graph3--values
...........
x y
0.1 0.8
0.2 0.9
0.3 0.10


Now I want Excel to plot the graph1 and graph2
with the give function y=e^x (superimposed).

Please help me .

Three graph into one
 

Brain fart...you will want to set the Plot background to None ALSO! Sorry about that.

On Fri, 30 Apr 2004 08:17:20 -0700, Toby Erkson < wrote:

I had a problem where I needed three pivot charts on top of each other...similar to the end result you're looking for. What I discovered is that you can set
the Chart background (not the Plot background!) to None and move each chart on top of another so the others show through:
right click on the Chart background
select Format Chart Area...
click the None radio button located in the top right area (in the Area box)
click OK
Now if you click somewhere else on the sheet or simply tap the 'Esc' keep the focus will leave the chart you selected and you'll see it become transparent!

If you do this process with each chart you can place them on top of each other. You may need to adjust or remove axis titles and legends from the charts. If
you use the same axis then you can clear all of the charts but one (which would show). For example, the x-axis for my charts were all the same, quarter and
year, but the y-axis was different (avg. # of calls, avg. call time, & avg. revenue) so I removed all titles, y-axis and legends but on the last chart I left
the x-axis alone since it was the same for all three charts. I moved the charts on top of each other so the borders lined up and, as far as the manager was
concerned, it looked like one chart with three different plots :-) Of course, I tweaked it so the plots had different colors and I also showed the charts
grouped together (but not on top of one another) on another sheet so they could be viewed as individuals.

HTH,
Toby Erkson
Oregon, USA

On 30 Apr 2004 03:55:57 -0700, (why) wrote:

suppose I have

y=e^x [where x=0.5 to 1.5];

and after interpolation I found x ,y values

graph2--values
............
x y
0.1 0.5
0.2 0.6
0.3 0.8
---------------
graph3--values
...........
x y
0.1 0.8
0.2 0.9
0.3 0.10


Now I want Excel to plot the graph1 and graph2
with the give function y=e^x (superimposed).

Please help me .

Toby Erkson
Oregon, USA