Data Labels- POssible to show data value and data label together?

K

kippers

Hi,

I would like to show both the data label and the data value at the same time
on a number of data points on a graph- however Excel (2000) only seems to let
me select one or the other- does anyone know if it is possible to show both?

Any help gratefully appreciated!

R
 
J

Jon Peltier

Excel 2002 introduced the built-in ability to combine data in data labels.

However, if you aren't using 2002 or later, or if you have more intricate
requirements, you can still get customized labels. In a range of the
worksheet, use formulas to construct the labels you want from the data. Then
use one of these free Excel tools to add these labels to the chart:

Rob Bovey's Chart Labeler, http://appspro.com/Utilities/ChartLabeler.htm
John Walkenbach's Chart Tools,
http://www.j-walk.com/ss/excel/files/charttools.htm

- Jon
 

Ask a Question

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.

Ask a Question

Similar Threads

How select all data points/data labels at once (to format)? 2
Data labels on chart 1
Data Labels - I Only Want One 1
adding data labels to an XY scatterplot 1
Data label doesn't match data point! 4
how do I fix the data label to one data point? 2
Data Labels Disappearing 0
Filtering data for scatter plot with chart labels 2

Top