A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Picture options grayed out



 
 
Thread Tools Display Modes
  #1  
Old September 15th, 2003, 08:25 PM
Ray Knight
external usenet poster
 
Posts: n/a
Default Picture options grayed out

In Excel 2002, Office XP, when I insert a picture for the
background of a chart, it is squeezed and stretched in
the chart (though not in the preview). The picture
options are grayed out. I tried it with both JPEG and
bitmap graphics with the same problem.

Also, in the gradient fill, the transparency sliders are
inoperative.

Any ideas how to activate these features?

Ray
  #2  
Old September 16th, 2003, 12:20 AM
Debra Dalgleish
external usenet poster
 
Posts: n/a
Default Picture options grayed out

Those settings are not available in all situations. If you're working
with an AutoShape, most of the options will be available, but for a
chart background they aren't, and there's no setting that you can change
to make them available.

Ray Knight wrote:
In Excel 2002, Office XP, when I insert a picture for the
background of a chart, it is squeezed and stretched in
the chart (though not in the preview). The picture
options are grayed out. I tried it with both JPEG and
bitmap graphics with the same problem.

Also, in the gradient fill, the transparency sliders are
inoperative.


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

  #3  
Old September 18th, 2003, 02:13 AM
Ray Knight
external usenet poster
 
Posts: n/a
Default Picture options grayed out

Thanks for the info, Debra.

Ray

  #4  
Old September 18th, 2003, 02:20 AM
Ray Knight
external usenet poster
 
Posts: n/a
Default Picture options grayed out

Hmm.

No doubt you're right, Debra. However, in checking
furthre, I find in the Excel Help file the following
instructions:

"Use a picture in a chart
Most charts or chart items


To specify a picture, click Select Picture.
In the Look in box, click the drive, folder, or Internet
location that contains the picture, and then double-click
the picture you want.
On the Picture tab, select the options you want."


According to that, the options should be available to
change in a chart. Is that an error in the Help file?

Ray



-----Original Message-----
Those settings are not available in all situations. If

you're working
with an AutoShape, most of the options will be

available, but for a
chart background they aren't, and there's no setting

that you can change
to make them available.

Ray Knight wrote:
In Excel 2002, Office XP, when I insert a picture for

the
background of a chart, it is squeezed and stretched in
the chart (though not in the preview). The picture
options are grayed out. I tried it with both JPEG and
bitmap graphics with the same problem.

Also, in the gradient fill, the transparency sliders

are
inoperative.


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

.

  #5  
Old September 18th, 2003, 02:42 AM
Debra Dalgleish
external usenet poster
 
Posts: n/a
Default Picture options grayed out

Step 1 of the instructions say:
Click the data markers in column, bar, area, bubble, 3-D line, and
filled radar charts, the chart area, the plot area, or the legend in 2-D
and 3-D charts, or the 3-D walls or floor that you want to use a picture
for.

Some of the options are available for some chart objects. For example,
if you add a picture to a data marker in a column chart, the Format
options are available. If you add a picture to a data marker in a 3D
column chart, the Format and Apply to options are available.

But for the chart area (background), which is where you wanted your
picture, no options are available.

Ray Knight wrote:
Hmm.

No doubt you're right, Debra. However, in checking
furthre, I find in the Excel Help file the following
instructions:

"Use a picture in a chart
Most charts or chart items


To specify a picture, click Select Picture.
In the Look in box, click the drive, folder, or Internet
location that contains the picture, and then double-click
the picture you want.
On the Picture tab, select the options you want."


According to that, the options should be available to
change in a chart. Is that an error in the Help file?

Ray




-----Original Message-----
Those settings are not available in all situations. If


you're working

with an AutoShape, most of the options will be


available, but for a

chart background they aren't, and there's no setting


that you can change

to make them available.

Ray Knight wrote:

In Excel 2002, Office XP, when I insert a picture for


the

background of a chart, it is squeezed and stretched in
the chart (though not in the preview). The picture
options are grayed out. I tried it with both JPEG and
bitmap graphics with the same problem.

Also, in the gradient fill, the transparency sliders


are

inoperative.


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

.




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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:56 PM.


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