#1   Report Post  
Daniell
 
Posts: n/a
Default Data Labels

On the Chart Options there is an option DATA LABELS. This option lets you
print the following VALUE, PERCENT, LABEL and LABEL + PERCENT. Is there any
way that you can print the Value and the Label. Or is there anyway you can
modify any part of what you want to print beside the section of the pie chart.
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

You can manually change the text within each data label. This is rather
tedious, so you can download one of the following Excel add-ins, which
allow you to select a worksheet range to use as labels for your points;
both are free, easy to install and use. If you want any particluar
label, you can write a formula in a range of cells that concatenates the
value and the label, then use this range for the labels.

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

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


Daniell wrote:

On the Chart Options there is an option DATA LABELS. This option lets you
print the following VALUE, PERCENT, LABEL and LABEL + PERCENT. Is there any
way that you can print the Value and the Label. Or is there anyway you can
modify any part of what you want to print beside the section of the pie chart.

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
changing thwe width of data labels? Howard Charts and Charting in Excel 2 July 12th 05 07:26 AM
"Bring to Front" Data Labels? Rob Charts and Charting in Excel 2 April 3rd 05 04:59 PM
Is there a way of attaching data labels from a text range to dat. Peter Sailing by Charts and Charting in Excel 3 March 31st 05 02:25 PM
VBA to change size of data labels? Jason Weiss Charts and Charting in Excel 2 March 24th 05 08:24 PM
Using data as data labels cheekymonkey Excel Discussion (Misc queries) 1 February 18th 05 11:07 PM


All times are GMT +1. The time now is 07:16 PM.

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

About Us

"It's about Microsoft Excel"