Custom chart problems

Andrea -

I've never noticed this behavior, but you're right, custom user-defined
charts don't support invisible chart area formatting.

The best I can suggest is a workaround. Select a chart, start the macro
recorder, call the macro ClearChartBackground or something equally
descriptive, and reformat the chart area to be invisible. On the View
menu, choose Toolbars, then choose Customize. Click the Commands tab,
select Macros in the left list, and drag Custom Button from the right
list to a command bar somewhere. Right click on the smiley face button,
change it to a reasonable name (which will be the tooltip), change a
different button image or draw your own, and most important, assign the
macro you just recorded to this button. Whenever you make a chart, click
on this button to clear the background.

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

Andrea56 wrote:

In creating a custom chart, Excel doesn't seem to keep the border and
chart background settings at "None"...all the other formatting is
retained (fonts, etc.), but the chart always reverts to a solid white
background and a thin black border around the chart. I have to go in
manually and remove these each time. Is there any way of creating and
retaining these 2 settings as default or as part of a custom chart?

Thanks
Andrea


---
Message posted from http://www.ExcelForum.com/