ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Graphics Questions (https://www.excelbanter.com/new-users-excel/232667-graphics-questions.html)

Robert11[_3_] June 3rd 09 12:18 AM

Graphics Questions
 
Hi,

Using Excel 2007

Two questions, please:

I added some text to a chart.
Figured out how to do this !

Now I want to put a box around it, but have the text show.
Was able to select a rectangular shape, but it comes up blue.

How do I get just the rectangular box outline to show, and the text also to
show (clear, no color) ?

b. They have many shapes you can select, apparently, but no straight dashed
line.
Is there one, somewhere ?

Thanks,
Bob



Bernard Liengme[_3_] June 3rd 09 02:10 AM

Graphics Questions
 
Add the rectangle; right click it an Edit Text
You can also Format Shape to change colour
When you add a shape make sure you first select (click on) the chart so that
the two objects are grouped

I suspect the text you are talking about is in a colourless/borderless text
box; this too could be formatted to add colour and/or border
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Robert11" wrote in message
...
Hi,

Using Excel 2007

Two questions, please:

I added some text to a chart.
Figured out how to do this !

Now I want to put a box around it, but have the text show.
Was able to select a rectangular shape, but it comes up blue.

How do I get just the rectangular box outline to show, and the text also
to show (clear, no color) ?

b. They have many shapes you can select, apparently, but no straight
dashed line.
Is there one, somewhere ?

Thanks,
Bob





All times are GMT +1. The time now is 02:51 AM.

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