| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Charts
I am writing a macro that creates charts. In order to control these charts
better I want to add them as chart objects. Therefore I write the code as follwing: Set chtChart = Charts.Add With chtChart .Name = "test chart" .ChartType = xlUserDefined .TypeName:="Standard" The problem is that I do not use the standard charts in Excel but one type that my firm uses. How do I write code so that the chart object is of correct type? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Charts
Hi
See what the macro recorder does with your custom chart type. regards Paul Fabrizio wrote: I am writing a macro that creates charts. In order to control these charts better I want to add them as chart objects. Therefore I write the code as follwing: Set chtChart = Charts.Add With chtChart .Name = "test chart" .ChartType = xlUserDefined .TypeName:="Standard" The problem is that I do not use the standard charts in Excel but one type that my firm uses. How do I write code so that the chart object is of correct type? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| charts toolbar / charts disappeared | Charts and Charting in Excel | |||
| link excel charts to web pages and update charts automatically | Charts and Charting in Excel | |||
| Charts - How to have multiple charts share a legend. | Charts and Charting in Excel | |||
| interactive charts for stacked bar charts | Charts and Charting in Excel | |||
| Matching the colors Column Charts and Pie Charts | Charts and Charting in Excel | |||
Linear Mode
