PC Review


Reply
Thread Tools Rate Thread

Change background / color of chart worksheet?

 
 
Maj_USA_Ret
Guest
Posts: n/a
 
      4th Mar 2010
Need steps to change the color or backgound of the worksheet that is a chart.
Have multiple tabs in workbook that are just the charts. Only option for
background is to use Format-Sheet-Background. That changes background of
chart, but not the grey areas around the chart on the chart tab.
 
Reply With Quote
 
 
 
 
trip_to_tokyo
Guest
Posts: n/a
 
      4th Mar 2010
You need to select the Chart Area (what you call the, "grey areas around the
chart") and format that.

There are 2 separate, "parts" to a chart:-

1. The Plot Area (which you seem to have formatted OK) and the

2. Chart Area.

You need to select each of them to format them.

If my comments have helped please hit Yes.

Thanks.



"Maj_USA_Ret" wrote:

> Need steps to change the color or backgound of the worksheet that is a chart.
> Have multiple tabs in workbook that are just the charts. Only option for
> background is to use Format-Sheet-Background. That changes background of
> chart, but not the grey areas around the chart on the chart tab.

 
Reply With Quote
 
Jon Peltier
Guest
Posts: n/a
 
      9th Mar 2010
You're stuck with the gray areas, as far as I can tell.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 3/4/2010 1:32 PM, Maj_USA_Ret wrote:
> Need steps to change the color or backgound of the worksheet that is a chart.
> Have multiple tabs in workbook that are just the charts. Only option for
> background is to use Format-Sheet-Background. That changes background of
> chart, but not the grey areas around the chart on the chart tab.

 
Reply With Quote
 
AdamV
Guest
Posts: n/a
 
      12th Mar 2010
The areas either side of a chart seem to be coloured according to the
colour scheme you choose, in Excel 2007, ie based on the blue, silver or
black theme.
Howver, if you resize the chart and/or zoom in/out you can fill the
available space so you can't see them, but this depends on your monitor
resolution and aspect ration - your colleagues may get a different view
of the chart than you.

Adam

On 04/03/2010 18:32, Maj_USA_Ret wrote:
> Need steps to change the color or backgound of the worksheet that is a chart.
> Have multiple tabs in workbook that are just the charts. Only option for
> background is to use Format-Sheet-Background. That changes background of
> chart, but not the grey areas around the chart on the chart tab.

 
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
Change background color of query results from access in worksheet Chuck W Microsoft Excel Discussion 1 23rd Apr 2010 11:21 PM
Checkbox to change background color, font color and remove/ add bo Sara Microsoft Excel Misc 1 11th Nov 2008 08:17 PM
How do I change the background color and font color in word docum MarieInLaguna Microsoft Word Document Management 1 13th Aug 2008 05:02 PM
Change background color of organizational chart =?Utf-8?B?RWxsZW4=?= Microsoft Powerpoint 3 28th Nov 2005 06:36 PM
change notepad background color/text color Jonathan Windows XP Customization 4 3rd Oct 2003 11:18 PM


Features
 

Advertising
 

Newsgroups
 


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