#1   Report Post  
Posted to microsoft.public.excel.misc
JaB JaB is offline
external usenet poster
 
Posts: 23
Default Chart border

Morning

I have a pie chart that is sitting upon a graphic, however, the chart area
is quite large to ensure that the chart is of appropriate size.
Unfortunately, this means that the border around the chart is obscuring much
of the graphic behind.

Does anyone know how to make the area surrounding the chart transparent?

Thanks
Justin
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default Chart border

I'm not sure there is a way to make it transparent if you have your graphic
saved as a picture you can use it as your backround. Just right click outside
of the chart, click on Format chart area, click Fill Effects,then choose the
picture tab. From there you can select any picture saved on your computer as
your backround. Hope this helps.

"JaB" wrote:

Morning

I have a pie chart that is sitting upon a graphic, however, the chart area
is quite large to ensure that the chart is of appropriate size.
Unfortunately, this means that the border around the chart is obscuring much
of the graphic behind.

Does anyone know how to make the area surrounding the chart transparent?

Thanks
Justin

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default Chart border

You can make the chart area transparent: double click, and on the Patterns
tab, choose None for Area. You can also make the pie larger within the chart
area, so the chart area doesn't need to be so large. The pie sits within a
square plot area which is usually not visible but touches the pie at the
top, bottom, and both sides. So click in one of the corners close to the
pie, then stretch the plot area to fill more of the chart area.

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


"JaB" wrote in message
...
Morning

I have a pie chart that is sitting upon a graphic, however, the chart area
is quite large to ensure that the chart is of appropriate size.
Unfortunately, this means that the border around the chart is obscuring
much
of the graphic behind.

Does anyone know how to make the area surrounding the chart transparent?

Thanks
Justin



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
How to deselect a selected chart programatically? sr152 Charts and Charting in Excel 3 January 28th 06 03:22 AM
How can I combine a stacked bar chart with stacked colum chart? Sin Charts and Charting in Excel 8 December 20th 05 03:50 AM
Chart Property Confusion Arturo Charts and Charting in Excel 4 December 16th 05 05:13 AM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Pivot Table border formatting and pivot chart formatting [email protected] Excel Discussion (Misc queries) 0 July 22nd 05 02:22 PM


All times are GMT +1. The time now is 01:25 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"