| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I put custom data labels on charts in Excel?
I have a chart showing burn rates (fairly small numbers) and EACs/ETCs(Relly
big numbers). I have set up 2 Y-Axis, but this stretches the burn rate a lot, so if it changes a little bit, it adjusts the axis and suddenly, a 1% spike goes all the way from the bottom edge to the top. I know I can define the axis to compensate, but then if there really were a spike, it has the potential to go off the page, something I'm not sure people will know how to fix when I leave this internship in a couple weks. What I want to do is add another set of data, a percent change in the burn rate. Obviously, I don't want to show this as another line, but rather as a label on the burn rate data points. This should be really easy, but I can't find a way to do it. Also, I'm pretty iffy about downloading things as this is a government-owned computer. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I put custom data labels on charts in Excel?
Matt -
There are a couple free Excel utilities that apply labels from a worksheet range to a chart series. Both integrate seamlessly with Excel: 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 _______ "mattgoof2005" wrote in message ... I have a chart showing burn rates (fairly small numbers) and EACs/ETCs(Relly big numbers). I have set up 2 Y-Axis, but this stretches the burn rate a lot, so if it changes a little bit, it adjusts the axis and suddenly, a 1% spike goes all the way from the bottom edge to the top. I know I can define the axis to compensate, but then if there really were a spike, it has the potential to go off the page, something I'm not sure people will know how to fix when I leave this internship in a couple weks. What I want to do is add another set of data, a percent change in the burn rate. Obviously, I don't want to show this as another line, but rather as a label on the burn rate data points. This should be really easy, but I can't find a way to do it. Also, I'm pretty iffy about downloading things as this is a government-owned computer. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I put custom data labels on charts in Excel?
I take it then that you can't do it without downloading something? (Frickin'
DOE computers) "Jon Peltier" wrote: Matt - There are a couple free Excel utilities that apply labels from a worksheet range to a chart series. Both integrate seamlessly with Excel: 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 _______ "mattgoof2005" wrote in message ... I have a chart showing burn rates (fairly small numbers) and EACs/ETCs(Relly big numbers). I have set up 2 Y-Axis, but this stretches the burn rate a lot, so if it changes a little bit, it adjusts the axis and suddenly, a 1% spike goes all the way from the bottom edge to the top. I know I can define the axis to compensate, but then if there really were a spike, it has the potential to go off the page, something I'm not sure people will know how to fix when I leave this internship in a couple weks. What I want to do is add another set of data, a percent change in the burn rate. Obviously, I don't want to show this as another line, but rather as a label on the burn rate data points. This should be really easy, but I can't find a way to do it. Also, I'm pretty iffy about downloading things as this is a government-owned computer. |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I put custom data labels on charts in Excel?
How does this work with data labels? I've tried every combination I
can think of to link a chart data point with a data label in an adjacent column, to no avail. I would be most appreciative of any help here... On Wed, 26 Jul 2006 20:06:53 -0400, Tushar Mehta wrote: You can add custom labels by hand though it can be PITA for more than a few labels. The technique for Dynamic Chart Title http://www.tushar-mehta.com/excel/ne...tle/index.html also works with labels. |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I put custom data labels on charts in Excel?
One by one, you could select a label (click once to select a series of
labels, then again to select a single label). type = in the formula bar, then click on a cell. To do a whole series at a time, check out one of these utilities: 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 _______ "Elmer Smurdley" wrote in message ... How does this work with data labels? I've tried every combination I can think of to link a chart data point with a data label in an adjacent column, to no avail. I would be most appreciative of any help here... On Wed, 26 Jul 2006 20:06:53 -0400, Tushar Mehta wrote: You can add custom labels by hand though it can be PITA for more than a few labels. The technique for Dynamic Chart Title http://www.tushar-mehta.com/excel/ne...tle/index.html also works with labels. |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I put custom data labels on charts in Excel?
Can you download it at home and bring it in on a flash drive? Or are those
taboo, too? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "mattgoof2005" wrote in message ... I take it then that you can't do it without downloading something? (Frickin' DOE computers) "Jon Peltier" wrote: Matt - There are a couple free Excel utilities that apply labels from a worksheet range to a chart series. Both integrate seamlessly with Excel: 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 _______ "mattgoof2005" wrote in message ... I have a chart showing burn rates (fairly small numbers) and EACs/ETCs(Relly big numbers). I have set up 2 Y-Axis, but this stretches the burn rate a lot, so if it changes a little bit, it adjusts the axis and suddenly, a 1% spike goes all the way from the bottom edge to the top. I know I can define the axis to compensate, but then if there really were a spike, it has the potential to go off the page, something I'm not sure people will know how to fix when I leave this internship in a couple weks. What I want to do is add another set of data, a percent change in the burn rate. Obviously, I don't want to show this as another line, but rather as a label on the burn rate data points. This should be really easy, but I can't find a way to do it. Also, I'm pretty iffy about downloading things as this is a government-owned computer. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| There is a bug in formatting charts data labels. | Excel Worksheet Functions | |||
| Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
| XL Charts: Let my mouse drag all data labels for a whole series. | Charts and Charting in Excel | |||
| Merging different quantites of labels based on Excel data | Excel Worksheet Functions | |||
| Excel charts should let me select a range for data labels. | Charts and Charting in Excel | |||
Hybrid Mode
