Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel spreadsheets with data, Powerpoint charts... and VBA! | Excel Discussion (Misc queries) | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
excel data label format special number characters (part 2) | Excel Discussion (Misc queries) | |||
Can I create custom forms to add data to a Excel Spreadsheet? How. | Excel Discussion (Misc queries) |