Change background / color of chart worksheet?


M

Maj_USA_Ret

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.
 
Ad

Advertisements

T

trip_to_tokyo

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.
 
Ad

Advertisements

A

AdamV

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top