View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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?