PC Review


Reply
Thread Tools Rate Thread

Changing chart background color in Excel 97 SR 2

 
 
whayface
Guest
Posts: n/a
 
      29th Apr 2004


I am fairly new to this so please bear with me.

I have a chart based on numbers in a spread that has a grey background (The chart) but I
would like the background to be white and can not get it to change.

I right clicked on the chart and went to Format Chart Area, Patterns, Fill Effects,
Patterns and changed the background to white but the ok button is greyed out.

Am using Excel (Office) 97 SR 2

TIA

http://members.aol.com/larrystark/


 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      30th Apr 2004
Right click (or double click) on the gray region, which is the Plot Area.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

whayface wrote:

>
> I am fairly new to this so please bear with me.
>
> I have a chart based on numbers in a spread that has a grey background (The chart) but I
> would like the background to be white and can not get it to change.
>
> I right clicked on the chart and went to Format Chart Area, Patterns, Fill Effects,
> Patterns and changed the background to white but the ok button is greyed out.
>
> Am using Excel (Office) 97 SR 2
>
> TIA
>
> http://members.aol.com/larrystark/
>
>


 
Reply With Quote
 
whayface
Guest
Posts: n/a
 
      1st May 2004

Tryed it and nothing happened of course like I said I am new to this so -------

>Right click (or double click) on the gray region, which is the Plot Area.
>
>>
>> I am fairly new to this so please bear with me.
>>
>> I have a chart based on numbers in a spread that has a grey background (The chart) but I
>> would like the background to be white and can not get it to change.
>>
>> I right clicked on the chart and went to Format Chart Area, Patterns, Fill Effects,
>> Patterns and changed the background to white but the ok button is greyed out.
>>
>> Am using Excel (Office) 97 SR 2
>>
>> TIA
>>
>> http://members.aol.com/larrystark/
>>
>>


 
Reply With Quote
 
Jon Peltier
Guest
Posts: n/a
 
      1st May 2004
I can't think of why this is happening. Does it happen on all charts, or
just this one? (If it's just this one, I suggest recreating it.)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

whayface wrote:

> Tryed it and nothing happened of course like I said I am new to this so -------
>
>
>>Right click (or double click) on the gray region, which is the Plot Area.
>>
>>
>>>I am fairly new to this so please bear with me.
>>>
>>>I have a chart based on numbers in a spread that has a grey background (The chart) but I
>>>would like the background to be white and can not get it to change.
>>>
>>>I right clicked on the chart and went to Format Chart Area, Patterns, Fill Effects,
>>>Patterns and changed the background to white but the ok button is greyed out.
>>>
>>>Am using Excel (Office) 97 SR 2
>>>
>>>TIA
>>>
>>>http://members.aol.com/larrystark/
>>>
>>>

>
>


 
Reply With Quote
 
Debra Dalgleish
Guest
Posts: n/a
 
      2nd May 2004
Right-click on the grey background, and choose Format Plot Area
Do NOT click the Fill Effects button.
Just select the white colour on the Patterns tab, then click OK.


whayface wrote:
>
> I am fairly new to this so please bear with me.
>
> I have a chart based on numbers in a spread that has a grey background (The chart) but I
> would like the background to be white and can not get it to change.
>
> I right clicked on the chart and went to Format Chart Area, Patterns, Fill Effects,
> Patterns and changed the background to white but the ok button is greyed out.
>
> Am using Excel (Office) 97 SR 2



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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing individual data label font color in Excel Chart cab58 Microsoft Excel Discussion 1 23rd Apr 2007 03:59 PM
Excel chart, changing into sections to color =?Utf-8?B?cnJ1cHA=?= Microsoft Excel Charting 2 6th Jun 2006 09:35 AM
Gridlines into excel spreadsheet after changing background color =?Utf-8?B?am1jdXJseQ==?= Microsoft Excel Worksheet Functions 2 1st Jun 2005 08:10 PM
Changing the color of a specific gridline in an imported Excel Chart =?Utf-8?B?SmFtaWU=?= Microsoft Powerpoint 3 19th Jan 2004 05:01 PM
Changing default chart background color Pat Microsoft Excel Charting 1 1st Sep 2003 08:11 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:14 PM.