Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can not get Excel macros to format/save charts--help??? :(((((
Help??:((( I've spent the last 5 days searching on this forum for problems
similar to what I have but no luck! I am trying to use Excel macro to create a simple bar chart and to format the chart type/etc...but the macro keeps erroring when I try to run it. The debug points to " ' Set ActiveChart = ActiveSheet.ChartObjects(Chart1)" run time error 1004. No matter what I name the chart, it errors. I'm advanced at Excel but not editing macros with VB. I'm at my wits end and hope that someone can help me :(( |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can not get Excel macros to format/save charts--help??? :(((((
Hi,
You do not set the Activechart object in that way. It is automatically assigned by activating the chart. Activesheet.chartobjects("Chart 1").activate Now you can use the Activechart object, for example. Msgbox "Chart has " & Activechart.seriescollection.count & " series" Cheers Andy On 18/03/2010 21:04, AccessQuestion wrote: Help??:((( I've spent the last 5 days searching on this forum for problems similar to what I have but no luck! I am trying to use Excel macro to create a simple bar chart and to format the chart type/etc...but the macro keeps erroring when I try to run it. The debug points to " ' Set ActiveChart = ActiveSheet.ChartObjects(Chart1)" run time error 1004. No matter what I name the chart, it errors. I'm advanced at Excel but not editing macros with VB. I'm at my wits end and hope that someone can help me :(( -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can not get Excel macros to format/save charts--help??? :(((((
Hi Andy,
Thanks for your answer but I'm not sure I understand. This is my code and the debugger keeps stopping on ActiveChart.SetSourceData line. ' ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.PlotArea.Select ' ActiveChart.SetSourceData -- mfg2529 "Andy Pope" wrote: Hi, You do not set the Activechart object in that way. It is automatically assigned by activating the chart. Activesheet.chartobjects("Chart 1").activate Now you can use the Activechart object, for example. Msgbox "Chart has " & Activechart.seriescollection.count & " series" Cheers Andy On 18/03/2010 21:04, AccessQuestion wrote: Help??:((( I've spent the last 5 days searching on this forum for problems similar to what I have but no luck! I am trying to use Excel macro to create a simple bar chart and to format the chart type/etc...but the macro keeps erroring when I try to run it. The debug points to " ' Set ActiveChart = ActiveSheet.ChartObjects(Chart1)" run time error 1004. No matter what I name the chart, it errors. I'm advanced at Excel but not editing macros with VB. I'm at my wits end and hope that someone can help me :(( -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can not get Excel macros to save chart format -lost in space! | Charts and Charting in Excel | |||
Imported Visual Basic Module - Save Macros for use in Excel | Excel Discussion (Misc queries) | |||
How to save & send Excel files without macros. | Excel Discussion (Misc queries) | |||
Remove all macros and objects in Excel, Save and Quit | Excel Discussion (Misc queries) | |||
Excel Charts(Graphs) & Macros | Excel Discussion (Misc queries) |