2 data labels per bar?

Question

Hi,

Is it possible to add two labels per category to a stacked column chart?

For example

6% and beneth this label I want to add the actual # lets says 200

on a column chart.

Thanks,

EA

Answer 1

Tushar, I am unable to make your instructions (at your link, above) work in 2007. No link is created...

Answer 2

Did you get something to work? I have the exact same situation!

Answer 3

its more of a label to the side of each label to inform them the actual #s... believe me nothing would  make me happier to keep it simple but when you get a request for it you have to try to make it work.

Answer 4

Sounds to me like what you can do and what you should do are not the same.

If people really need to read the exact figures for actual values and percentages, they will be much easier to find and interpret in a table, rather than scattered all over a chart.

If people want to see patterns in the data and quickly assimilate this without having to compute things, then a simple, uncluttered chart is ideal.

So if you are creating a report for a mixed audience, maybe you need both. But adding lots of labels all over your chart is giving nobody the best result.

---

Adam Vero MCT, MMI, MBMSS:CRM 4, MCSA:Messaging http://www.meteorit.co.uk

Answer 5

Use a formula to aggregate the information in a worksheet cell and then link the data label to the worksheet cell.  See

Data Labels

http://www.tushar-mehta.com/excel/newsgroups/data_labels/

---

Tushar Mehta (Technology and Operations Consulting)

www.tushar-mehta.com (Excel and PowerPoint add-ins and tutorials)

Microsoft MVP Excel 2000-Present