How do I show both data labels and values?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using a basic stacked chart w/ five data series. How do I show *both*
data labels and data values? Excel seems to only allow me to select one or
the other to display at a time. How can I do what I intend?
 
In a column, write a formula to compine both items into a single label.
Something like one of these:

=A1&" "&B1
=A1&"-"&B1
=A1&CHAR(10)&B1

Use a third party data labels to assign the labels from this extra range
to the series. Here are two good ones, free to download, easy to install
and use:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top