ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Adding text in a chart (https://www.excelbanter.com/charts-charting-excel/160217-adding-text-chart.html)

sadman49

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.

Jon Peltier

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.




sadman49

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.





Del Cotter

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.


All times are GMT +1. The time now is 12:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com