Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to add asterisk to source data
We want to add an asterisk to several numbers in our data source, but when we
add the asterisk to the source data, it disappears from the chart. How can we keep it from doing that without putting the asterisk in a textbox and then moving it around all the time whenever there are changes in the chart? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to add asterisk to source data
If you put an asterix into a cell, you convert the cell from a number to a
text value, and it is interpreted as zero. Are the numbers data labels on points? You could highlight the particular values in a number of ways. You could put them into a different series with differently colored markers. You could put them into a different series with differently formatted text. etc. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Feather 52" wrote in message ... We want to add an asterisk to several numbers in our data source, but when we add the asterisk to the source data, it disappears from the chart. How can we keep it from doing that without putting the asterisk in a textbox and then moving it around all the time whenever there are changes in the chart? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to add asterisk to source data
On Thu, 21 Sep 2006, in microsoft.public.excel.charting,
Feather 52 said: We want to add an asterisk to several numbers in our data source, but when we add the asterisk to the source data, it disappears from the chart. How can we keep it from doing that without putting the asterisk in a textbox and then moving it around all the time whenever there are changes in the chart? Create a custom number format like one of these: General"*" 0.00"*" Whatever suits you. It should be just the format you're using already with "*" added on the end. Apply the format you created whenever you want to add an asterisk to a number, and the result will be a number that displays properly on your chart, but displays with an asterisk on your table. -- 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. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to add asterisk to source data
The numbers are data labels on points and the asterisk would highlight
certain numbers and then have a footnote related to the asterisk. Thank you anyway though. I appreciate your help. feather52 "Jon Peltier" wrote: If you put an asterix into a cell, you convert the cell from a number to a text value, and it is interpreted as zero. Are the numbers data labels on points? You could highlight the particular values in a number of ways. You could put them into a different series with differently colored markers. You could put them into a different series with differently formatted text. etc. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Feather 52" wrote in message ... We want to add an asterisk to several numbers in our data source, but when we add the asterisk to the source data, it disappears from the chart. How can we keep it from doing that without putting the asterisk in a textbox and then moving it around all the time whenever there are changes in the chart? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to auto-increment data source cell references when copying cha | Charts and Charting in Excel | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Setting hover data labels to cells other than source data | Excel Discussion (Misc queries) | |||
Data Source Name Not Found | Excel Worksheet Functions | |||
Adding more source data to existing scatter plot | Charts and Charting in Excel |