Adding text in a chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sadman49 - 30 Sep 2007 10:30 GMT

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.

Reply to this Message

Jon Peltier - 30 Sep 2007 13:36 GMT

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
_______

> Hello to all the brains out there.
> Im making a simple chart with just total time and lost time and causes for
[quoted text clipped - 3 lines]
> i'm using a simple bar graph for this.
> Hope you all can help.

Reply to this Message

sadman49 - 30 Sep 2007 14:19 GMT

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

> 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
[quoted text clipped - 18 lines]
> > i'm using a simple bar graph for this.
> > Hope you all can help.

Reply to this Message

Del Cotter - 30 Sep 2007 16:42 GMT

>>If you have a list of labels in the sheet, use one of these utilities
>>to make labeling much easier:
[quoted text clipped - 4 lines]
>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".

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

Reply to this Message