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 :-) Lucy -- MOS Master Instructor www.aneasiertomorrow.com.au PowerPoint Live 2007 28-31 October in New Orleans www.pptlive.com See you there
Change background for ALL charts without custom defining all chart
2 posts
• Page 1 of 1
- 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.
Next
Change background for ALL charts without custom defining all chart
by YW5lYXNpZXJ0b21vcnJvdw » Sat, 29 Sep 2007 12:23:03 GMT
Re: Change background for ALL charts without custom defining all chart
by 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 different 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? TIA! --
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 saving." 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 range. 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 JDB
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
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 19 guest