Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 11
Default Adding text in a chart

Hello to all the brains out there.
Im making a simple chart with just total time and lost time and causes for
that lost time. Adding the total time and lost time to the chart is easy
enough but i want to add a causes line which is just text, can this be done?,
i'm using a simple bar graph for this.
Hope you all can help.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Adding text in a chart

You can add data labels to the bars. The default options provide values or
category labels or whatever, but you can overwrite them. If you have a list
of labels in the sheet, use one of these utilities to make labeling much
easier:

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


"sadman49" wrote in message
...
Hello to all the brains out there.
Im making a simple chart with just total time and lost time and causes for
that lost time. Adding the total time and lost time to the chart is easy
enough but i want to add a causes line which is just text, can this be
done?,
i'm using a simple bar graph for this.
Hope you all can help.



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 11
Default Adding text in a chart

Thanks for the tips Jon but im on a works computer so no downloading allowed,
i can only work with what i have.

"Jon Peltier" wrote:

You can add data labels to the bars. The default options provide values or
category labels or whatever, but you can overwrite them. If you have a list
of labels in the sheet, use one of these utilities to make labeling much
easier:

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


"sadman49" wrote in message
...
Hello to all the brains out there.
Im making a simple chart with just total time and lost time and causes for
that lost time. Adding the total time and lost time to the chart is easy
enough but i want to add a causes line which is just text, can this be
done?,
i'm using a simple bar graph for this.
Hope you all can help.




  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 560
Default Adding text in a chart

On Sun, 30 Sep 2007, in microsoft.public.excel.charting,
sadman49 said:

"Jon Peltier" wrote:
If you have a list of labels in the sheet, use one of these utilities
to make labeling much easier:

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


Thanks for the tips Jon but im on a works computer so no downloading allowed,
i can only work with what i have.


Just bring a floppy into work and add the add-in from the floppy. It's
just a big Excel macro, so not subject to or detectable by works
policies about "unauthorised software".

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.
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
Adding text box to pie chart steph Charts and Charting in Excel 2 March 12th 07 01:33 PM
Adding text to equal text Frank Excel Discussion (Misc queries) 3 February 15th 07 03:25 PM
Adding Dashes in front of text using text formating Neal Excel Discussion (Misc queries) 1 November 27th 06 10:58 PM
Adding a certain text label in a excel chart Tim Charts and Charting in Excel 2 September 28th 05 08:03 PM
Adding a line Chart Type to a stacked-clustered Chart Type Debbie Charts and Charting in Excel 2 January 5th 05 11:25 PM


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