| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro that opens a window giving you info in a few cells | Excel Discussion (Misc queries) | |||
| chart or macro problem | Excel Worksheet Functions | |||
| Chart or macro problem | Excel Discussion (Misc queries) | |||
| Problem with empty cells when creating chart using vba | Charts and Charting in Excel | |||
| Macro giving errors at workbook open | Excel Discussion (Misc queries) | |||
Threaded Mode
