Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Excel Charts - Create a custom data label

Hi!

I create Metrics on various projects milestones. The output in the bar
graph captures the how many days early or how many days a project is
from it's start date till today. My data is organized on project
numbers on X-axis trended against days early (+ve) or days late( -ve)
on the y-axis. My issue is that I need to present the project
description that corresponds to the project number somewhere in the
chart.

Please provide your valueable assistance.

Regards,
Sunil

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Excel Charts - Create a custom data label

Apply a data label to the chart, either as a label on an existing plotted
point, or as a label to a new series added for this purpose. The advantage
of data labels is that they are linked to data points, meaning they are
attached to particular XY coordinates on the chart axes.

The default choices for data label text are rather slim, but you can edit
the text of a label and type your own text. Or you can select the label
(select the pseudo text box, but don't activate the text), type "=" in the
formula bar, and click on a cell, to display the cell's content in the
label.

These two Excel add-ins are free, easy to install, and easy to use, and
perform this last step automatically on single points or on a whole series:

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

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


"Sunil" wrote in message
oups.com...
Hi!

I create Metrics on various projects milestones. The output in the bar
graph captures the how many days early or how many days a project is
from it's start date till today. My data is organized on project
numbers on X-axis trended against days early (+ve) or days late( -ve)
on the y-axis. My issue is that I need to present the project
description that corresponds to the project number somewhere in the
chart.

Please provide your valueable assistance.

Regards,
Sunil



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
Excel spreadsheets with data, Powerpoint charts... and VBA! Petitboeuf Excel Discussion (Misc queries) 1 May 26th 06 11:15 AM
consolidation of tables in excel with text and figures samenvoegen van sheets Excel Worksheet Functions 8 March 2nd 06 03:27 PM
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 06:16 PM
excel data label format special number characters (part 2) todd Excel Discussion (Misc queries) 1 May 4th 05 04:08 PM
Can I create custom forms to add data to a Excel Spreadsheet? How. TomassoP Excel Discussion (Misc queries) 1 January 25th 05 08:54 PM


All times are GMT +1. The time now is 05:15 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"