Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / February 2004

Tip: Looking for answers? Try searching our database.

what's the formula for adding symbols in cells?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Debi - 25 Feb 2004 20:56 GMT
I have a chart that has blank info in the legend.  I want
to add an * to indicate something, but just inserting a
symbol doesn't work.  Any ideas?  Thanks.
Jon Peltier - 28 Feb 2004 03:17 GMT
Debi -

To add information to the legend, you need to add to a series name.
Right click on the chart, select Source Data from the pop up menu, click
on the series tab, select a series, and either type something in the
name box, or click in it and select a cell with the mouse.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

> I have a chart that has blank info in the legend.  I want
> to add an * to indicate something, but just inserting a
> symbol doesn't work.  Any ideas?  Thanks.
Debra Dalgleish - 28 Feb 2004 11:50 GMT
You can't type text in the legend, but you could add a text box to the
chart, and add your note there.

To add a text box,
Select the chart
Type your note, e.g.   *no data available for March 2002
   (you'll see the text in the formula bar as you type)
Press the Enter key
The text box will appear near the centre of the chart
Drag the text box to any location within the chart, and
   format it as desired.

> I have a chart that has blank info in the legend.  I want
> to add an * to indicate something, but just inserting a
> symbol doesn't work.  Any ideas?  Thanks.

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.