| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro creating chart gallery giving problem | Charts and Charting in Excel | |||
| Problem with empty cells when creating chart using vba | Charts and Charting in Excel | |||
| Problem with creating chart within existing worksheet. | Excel Programming | |||
| Need help w/ macro creating a chart | Excel Programming | |||
| Macro for creating a chart | Excel Programming | |||
Linear Mode
