Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Tom P
 
Posts: n/a
Default Watermark for Excel chart

Does anyone know how to create a watermark on an Excel Chart?
  #2   Report Post  
John Mansfield
 
Posts: n/a
Default

Tom,

You might try a few of things:

(1) Activate your chart by clicking on it. Type the word "Draft" and hit
the enter key. A textbox should appear with the word "Draft" on the chart.
Position the textbox to where you want it to be and format it accordingly.
(2) Double - click on the outside area of your chart. In the Format Chart
Area dialog box, set the Area to None. Do the same with the plot area. Now,
select a range on your spreadsheet that contains the text of the watermark
that you want. In this example, assume the text is in the range A1:C3.
Press the Shift key and go to Edit - Copy Picture *Appearance=As shown on
screen *Format=Picture. Select somewhere else inside of your sheet and go
to Edit - Paste. Now, size the picture made from the Excel range to the
size of your chart. Mve your chart over the Excel range picture. The group
both the chart and picture together. Make sure that the Excel range picture
is grouped behind the chart.
(3) Click on the plot area of your chart. Right click your mouse and go to
Selected Object - Fill Effects - Picture - Select Picture. This option
will allow you to import a .gif, .bmp, etc. picture type file directly into
the plot area of your chart. You can also export you own excel range as a
..gif file and then import that into your plot area. John Walkenbach's
(jwalk.com/ss) PUP6 addin will export a range as a graphic.

----
Regards,
John Mansfield
hppt://www.pdbook.com

"Tom P" wrote:

Does anyone know how to create a watermark on an Excel Chart?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
changing proportion of chart and data table Dawn Parks Charts and Charting in Excel 3 January 6th 05 01:18 AM
Problem with xlusrgal.xls file Alfred S C Lee Charts and Charting in Excel 2 December 29th 04 05:54 PM
Impedding/Overlaying Charts Phil Hageman Charts and Charting in Excel 4 December 17th 04 07:25 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM
Why do my text boxes disappear from my chart when I click out? Robboo Charts and Charting in Excel 1 November 27th 04 05:49 PM


All times are GMT +1. The time now is 03:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"