| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a Chart with a macro in 2007
I have data in a sheet that was built with a macro. In order to enhance this
data I want to chart it. I recorded the macro to chart it and it is included below. The problem is when I run the recorded macro it hangs up on the "ActiveSheet.Shapes.addchart.Select" . All this is the recorded macro. Can't seem to get around it. Recorded Macro. Range("B1:E54").Select ActiveSheet.Shapes.addchart.Select ActiveChart.SetSourceData Source:=Range("'52weeks'!$B$1:$E$54") ActiveChart.ChartType = x1LineMarkers When I record this macro it works perfectly. When I go to run it again it hangs up HELP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding commands to the Excel 2007 Chart context menu | Charts and Charting in Excel | |||
| Problem adding chart (Office 2007) | Charts and Charting in Excel | |||
| Adding Extra Data Row to Chart via Macro | Excel Programming | |||
| Adding data series to chart via macro | Charts and Charting in Excel | |||
| Adding chart using a macro | Excel Programming | |||
Threaded Mode
