Macro creating chart gallery giving problem

P

Pranav Vaidya

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Move Chart with Text 0
Word 2016 - Difficulties Learning Style Creation/Application 0
Odd Chart Format Results 1
Change ALL chart elements default font? 2
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard 2
"Charts Gallery File does not exist" message 4
x-axis scale changes 3
Macro to change position of chart labels on line chart 1

Top