No not really. If you have a Picture editing program you
might try the following. I used Paint Shop Pro to edit two
charts.
1. Create two charts of the same data in excel.
2. Resize both charts.
3. Remove the background on at least on of the charts (
the one to go at the front)
4. copy both charts in to the picture editor. Set the
width to 300 and the height to 100 pixels
5 copy the chart with the plain plot area into a new layer
on the other chart.
6 right click the top chart and choose properties.
7 set the opacity to about 50% this will allow the
background chart to show through.
You will probably have to try this a few times to get the
right effect but persevere.
No not really. If you have a Picture editing program you
might try the following. I used Paint Shop Pro to edit two
charts.
1. Create two charts of the same data in excel.
2. Resize both charts.
3. Remove the background on at least on of the charts (
the one to go at the front)
4. copy both charts in to the picture editor. Set the
width to 300 and the height to 100 pixels
5 copy the chart with the plain plot area into a new layer
on the other chart.
6 right click the top chart and choose properties.
7 set the opacity to about 50% this will allow the
background chart to show through.
You will probably have to try this a few times to get the
right effect but persevere.
I forgot to mention the obvious that the chart will then
be a picture so will not change if the basic data changes.
But you can use the picture for a Word Report and keep the
charts in the worksheet.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
