Chart - Stacked Column question

**TomBP** · 03-08-2009, 12:10 PM

Hi,

Please have a look at the picture in attachment. As you can see, there are 3 seperate charts. I was wondering if it was possible to incorporate these into one single chart.

Thanks in advance!

**Andy Pope** · 03-09-2009, 05:58 AM

Yes, if you lay your data out correctly.
See attached

**ChiTech** · 03-09-2009, 09:15 AM

Thank you, you just saved me tons of time and some $$!!
J

**TomBP** · 03-09-2009, 10:07 AM

Thanks Andy Pope

By the way, is it possible to add a percentage data label to a stacked column which is already displaying the value? See attached picture if necessary.

**Andy Pope** · 03-09-2009, 10:17 AM

You would need to create the data label text in some helper cells and then link data labels to cells.

This free addin will help with the linkage.
http://www.appspro.com/Utilities/ChartLabeler.htm