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
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 .
