Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 51
Default Data Labels- POssible to show data value and data label together?

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
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Data Labels- POssible to show data value and data label together?

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"kippers" wrote in message
...
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to show numbers on y-axis and percentages on data labels? Megan Charts and Charting in Excel 2 August 18th 08 09:30 PM
data labels to show value, label & percent nihad Charts and Charting in Excel 1 January 16th 06 09:39 PM
Show data used and percent label Desiree Charts and Charting in Excel 2 October 18th 05 04:34 PM
How do I hide data labels that show a zero value on histograms? saretta75 Charts and Charting in Excel 2 September 12th 05 04:01 PM
How do I show both data labels and values? Carter Devereaux Charts and Charting in Excel 1 June 26th 05 07:12 PM


All times are GMT +1. The time now is 03:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"