![]() |
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. |
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. |
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. |
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