Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How I type SOLD across column length without changing current data
|
#2
|
|||
|
|||
Hi,
You're a bit light on detail so here are a bunch of possible methods some or all of which may or may not be appropriate. Use the data label. Add another data series and use its data labels. (For both data label methods you can link the data labels to a cells contents. Try this free addin http://www.appspro.com/Utilities/ChartLabeler.htm) Add an dummy series and use a custom fill. Create a autoshape containing the word sold. Copy and paste this to the dummy data series. Set the value for a sold bar to that of the sold value whenever you whant the word Sold to appear. If none of these help or you do not know how to implement then then post back. Cheers Andy MommaRMe wrote: -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search a Column by text length | Excel Worksheet Functions | |||
another text to column problem | Excel Worksheet Functions | |||
Excel: How do I type a letter in a column and make a check mark a. | Excel Worksheet Functions | |||
Sum a column of variable length? | Excel Discussion (Misc queries) | |||
How to break up a column in a bar graph if I do not want to chang. | Charts and Charting in Excel |