PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Macro creating chart gallery giving problem

Reply

Macro creating chart gallery giving problem

 
Thread Tools Rate Thread
Old 08-08-2007, 12:02 PM   #1
=?Utf-8?B?UHJhbmF2IFZhaWR5YQ==?=
Guest
 
Posts: n/a
Default Macro creating chart gallery giving problem


Hi,
I have problem with a macro that creates chart gallery.
I have a chart gallery file as gallery.xls. I write all the charts from this
gallery to xlusrgal.xls in a macro. The macro runs fine and I get my chart
styles as well. However there is a problem, when I go to Excel and create a
new chart my chart styles are seen under custom types-->User defned. However
I lost charts under Custom types-->Built-in. Here's the code that I am using.

Application.AddChartAutoFormat sht, sht.Name,"Custom chart"

Any help on this is much appreciated. I am using Excel 2003 and Windows XP.

--
Pranav Vaidya
VBA Developer
PN, MH-India

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off