C
Cyndi
Is there any way to utilize the stacking and clustering
features in Excel charting simultaneously? Thank you.
features in Excel charting simultaneously? Thank you.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peter Atherton
Cyndi
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.
Good luck
Peter
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.
Good luck
Peter
P
Peter Atherton
Cyndi
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.
Good luck
Peter
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.
Good luck
Peter
P
Peter Atherton
Cyndi
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.
Regards
Peter
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.
Regards
Peter
D
Debra Dalgleish
If you stagger your data, you can create side-by-side stacked columns.
Bernard Liengme has an example and instructions on his site:
http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm
and the following MSKB article has an example:
XL2000: Creating Charts with Multiple Groups of Stacked Bars
http://support.microsoft.com/default.aspx?id=214119
Bernard Liengme has an example and instructions on his site:
http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm
and the following MSKB article has an example:
XL2000: Creating Charts with Multiple Groups of Stacked Bars
http://support.microsoft.com/default.aspx?id=214119
C
Cyndi
Thanks Everyone!
C
Cyndi
Thanks SOOO much!
-----Original Message-----
If you stagger your data, you can create side-by-side stacked columns.
Bernard Liengme has an example and instructions on his site:
http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm
and the following MSKB article has an example:
XL2000: Creating Charts with Multiple Groups of Stacked Bars
http://support.microsoft.com/default.aspx?id=214119
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
.