Change background for ALL charts without custom defining all chart



  • 1. How do I export graphs to ppt and...
    Hello: I would like to tell excel to export graphs I created in a workbook, to a powerpoint presentation. One graph per specific page in ppt. I would like that anytime I update the excel document it automatically updates the graph in the ppt presentation. Does anyone know how to do this? Thank you very much.
  • 2. VB Chart > Excel
    I have a vb program that pulls data from a database and displays it onscreen. This includes a chart - is there a quick way of bascially copying this chart into an excel spreadsheet via code from my program? I have already got my listboxes and so on to fill in their info onto a new blank sheet, but the chart is also going to be handy. I assume one way is to copy all the data from the chart to a hidden sheet and use that maybe, but I am hoping I can do something simpler... Ta, James.

Change background for ALL charts without custom defining all chart

Postby YW5lYXNpZXJ0b21vcnJvdw » Sat, 29 Sep 2007 12:23:03 GMT

Hello Excel Experts

I'm using 2003.

Here's the thing: I'm desiging a powerpoint template for a client and have 
advised him to use excel for all his charting as MSGraph is so completely 
hopeless. I know I can change chart colours through tools->options->colour 
and that I can then use that file to update charts in any other xls. I also 
know I can create user-defined charts with the fonts, background etc I want 
and share those. Thing is I don't know *exactly* what chart types my client 
may want to use (and, bless, neither does he at the mo). 

So, my question is: is there any way to set fonts & background defaults for 
all new charts without using the user-defined charts?

One solution seems to be to define one chart type, set it as default, tell 
him to use f11 and then chage chart type as I think this reatins 
backgrounds/fonts etc. Is that right? And is it the only way?

Thank you for your time :-)


MOS Master Instructor 

PowerPoint Live 2007 28-31 October in New Orleans
See you there

Re: Change background for ALL charts without custom defining all chart

Postby Jon Peltier » Sat, 29 Sep 2007 12:43:42 GMT

I've had nothing but trouble with the user defined chart gallery, probably 
because having all these different versions of Office fight over the same 
gallery file, and they've corrupted it. And as you say, each chart type 
needs its own gallery entry, and sometimes the specs about what chart types 
you will need haven't been written yet.

I used to have a VBA procedure I would run on a newly created chart which 
would adjust all of these various parameters for me. Font style and size, 
background fill color, even the margins around the plot area. Nothing too 
elegant, but you could place a button on a toolbar that would run the chart 
wizard, then run the fixit sub, so that the user never really knew that they 
didn't make that nice chart to begin with. Plus another button that fed the 
chart through fixit again, if you made it ugly again.

- Jon
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -  http://www.**--****.com/ 

"aneasiertomorrow" < XXXX@XXXXX.COM > wrote in 

Similar Threads:

1.Change background for ALL charts without custom defining all c

2.User-defined (Custom) Charts

Problem: Super-impose line chart over stacked column, both data sets are 
Data Set 1:
A2:A28 -- Market Segments
B1:I1 -- Months (Dec 2004 -to- July 2005)
B2:I28 -- Market share (%) values, each column (B:I) sums to 100%
Stacked column (market share) .. easy and done

Data Set 2:
Herfindahl Index - Values in B29:I29
Line plot over Months .. easy and done

I need to superimpose the line plot over the stacked column, how do i do 
that one?



3.Setting up a Custom type, User-defined, Default Chart

When I try to save the User-defined Chart, I get an error saying "can not 
save this workbook because another open workbook with the same name or 
add-in. Choose a different name, or close the other workbook or add-in before 

I don't have an add-in interfering with this, as far as I know.  I save the 
workbook under another name and the User-defined Chart is not saved.

How can I save a User-defined Chart and how can I make it my default?

I am using MS Excel 2000 (9.0.3821 SR1).

4.Custom app user-defined chart type deployment

I have an application that uses custom chart types. I'm 
now running Excel 2002 under XP Professional.  These 
chart types in prior version of Excel were stored in the 
XLgalry.xls, and more recently XLUSrgal.xls.   I can't 
find these files on my machine. 
1) What is the file and the path where these user-defined 
custom chart types are located?  Are they hidden?
2) Could I deploy this appplication by copying that file 
to the target machine's directory? (albeit risking an 
overwrite).  I want to avoid going over to each 
propective user's machine and updating chart types by 
opening Excel.
3) What is the most elegant, programmatic way of using 
the specialized chart types without overwriting custom 
chart types already defined on the target machine?

5.Horizontally Banded Chart Background. - on Stock charts

I have 3 series of data, Hi/Lo/Avg that I am plotting using a Stock
type chart with 3 data points.

I want to use a Horizontally Banded Background to indicate the desired

I have read and tested Jon P's excellent article on Horizontailly
Banded Chart Background, and tested it successfull on a line chart.

However when I test it on the 3 var Stock chart it does not work.

Can anyone give me a suggestion for a way to do what I want with
either my stock type of chart or an alternative way to show what I
want to indicate.

Thanks from American Samoa


6. Combo x-y chart and background areas for blood pressure chart

7. change worksheet data without changing chart

8. Cannot change criteria on copied chart without changing original c

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 19 guest