Custom chart problems

[Andrea56]

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

Thanks
Andre

 

[Jon Peltier]

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/
_______