Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Other than adding a text box, is there a way to add text in each column
individually? Example: I have a chart showing several tasks and the their cost is listed as a data label (aligned: outsided end). I'd like to add the hours it takes to complete the task in the column, near the bottom. If this is not possible, any recommendations? Thank you! |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
You can add data labels to the column, but you are already using data labels
for this series. What I would do is add a line chart series to the chart, with appropriate data values, and apply the data labels to this series. Format the line series to be invisible (no lines or markers). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jennifer" wrote in message ... Other than adding a text box, is there a way to add text in each column individually? Example: I have a chart showing several tasks and the their cost is listed as a data label (aligned: outsided end). I'd like to add the hours it takes to complete the task in the column, near the bottom. If this is not possible, any recommendations? Thank you! |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I'll try that when I get back to the office on Monday.
Thanks for your response! "Jon Peltier" wrote: You can add data labels to the column, but you are already using data labels for this series. What I would do is add a line chart series to the chart, with appropriate data values, and apply the data labels to this series. Format the line series to be invisible (no lines or markers). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jennifer" wrote in message ... Other than adding a text box, is there a way to add text in each column individually? Example: I have a chart showing several tasks and the their cost is listed as a data label (aligned: outsided end). I'd like to add the hours it takes to complete the task in the column, near the bottom. If this is not possible, any recommendations? Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 getting error_Using text to column | Excel Discussion (Misc queries) | |||
Excel 2000: Adding column D based on value in column A | Excel Worksheet Functions | |||
Combination Column and Stacked Column Chart in XL 2007 | Charts and Charting in Excel | |||
IF Function for column containing text - Excel 2007 | New Users to Excel | |||
Excel 2007 column chart fill question | Charts and Charting in Excel |