| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combine chart types using VBA
I'm trying to create a chart combining lines with columns. I know it can be
done manually, so I recorded a Macro to show me what commands to use. It recorded, for example: ActiveChart.SeriesCollection(seriesNumber).ChartTy pe = xlColumnClustered When I use this command on my VBA code changing the series from a xlLine Graph to xlColumnClustered, my whole graph series becomes Columns, not only the one I wanted to change. Can this be done by other way? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combine chart types using VBA
Can someone PLEASE tell me how to combine chart types using VBA?
Is it even possible? thanks "bbussoloti" wrote: I'm trying to create a chart combining lines with columns. I know it can be done manually, so I recorded a Macro to show me what commands to use. It recorded, for example: ActiveChart.SeriesCollection(seriesNumber).ChartTy pe = xlColumnClustered When I use this command on my VBA code changing the series from a xlLine Graph to xlColumnClustered, my whole graph series becomes Columns, not only the one I wanted to change. Can this be done by other way? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combine chart types using VBA
Ok i've done it. Thanks
"bbussoloti" wrote: Can someone PLEASE tell me how to combine chart types using VBA? Is it even possible? thanks "bbussoloti" wrote: I'm trying to create a chart combining lines with columns. I know it can be done manually, so I recorded a Macro to show me what commands to use. It recorded, for example: ActiveChart.SeriesCollection(seriesNumber).ChartTy pe = xlColumnClustered When I use this command on my VBA code changing the series from a xlLine Graph to xlColumnClustered, my whole graph series becomes Columns, not only the one I wanted to change. Can this be done by other way? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
| How do I combine stacked and clustered chart types? | Charts and Charting in Excel | |||
| Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Charts and Charting in Excel | |||
| How would i combine information of different types in Excel? | Excel Discussion (Misc queries) | |||
| Cannot combine stock charts with other chart types in Excel 2007 | Charts and Charting in Excel | |||
Linear Mode
