ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I create a label over a small chart? (https://www.excelbanter.com/excel-discussion-misc-queries/54167-how-can-i-create-label-over-small-chart.html)

Linds

How can I create a label over a small chart?
 
am trying toi create a "sold out" label to go across a small chart. Is that
possible in Excel?

Bryan Hessey

How can I create a label over a small chart?
 

You could try a Command Button, Caption = "Sold Out", background =
transparent.

via, View, Toolbars, Control Toolbox, click the first icon (Design
Mode), select a Command Button and draw the button size on the
worksheet, then rightmouse and Properties to set Caption and
BackStyle.





Linds Wrote:
am trying toi create a "sold out" label to go across a small chart. Is
that
possible in Excel?



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=482972


Cutter

How can I create a label over a small chart?
 

Use a text box (which you get from the drawing toolbar). Type and
format your text. Size the text box and position it over your chart.
Click on the edge of the text box and format it with no lines and no
fill.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=482972



All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com