ExcelVBA/Charts/ChartsVBA_ChartObj_4b.gif' alt='Activate Vba Excel' title='Activate Vba Excel' />Cannot Activate Chart Area in Chart. Chart Object Failed. If the chart has no data to plot, there may not be a plot area to select. Dont keep selecting all the objects. It will be faster and lessdistracting this way With Active. Sheet. Chart. ObjectsWhat. Vba Deactivate ChartExcel get index of current chart. That however fails with. Excel VBA Copy a chart and paste as an enhanced metafile. VBA Code Error Chart Title in. Cells2, 4 ActiveSheet. ChartObjectsChart 1. Activate ActiveChart. I would like to edit one chart using my VBA code. Cannot Activate Chart Area in Chart. Chart Object Failed. Cannot Activate Chart Area in Chart. Technical Articles Creating Charts with VBA in Word. Chart Activate the data before you can access the workbook salesChart. ChartData. Activate. Hi Experts, How to fix this The image below shows the error I get when the macro attempts the line ActiveSheet. ChartObjects Chart 1. Activate Chart 1. Reviews 1httpssocial. ForumsenUS2bf07fc4dbce4e0ca0d3a0e50f846a83runtimeerror1004methodselectofobjectchartsfailedforumexceldev hIDSERP,5626. Runtime error 1004 Method Select of object Charts. Hi Everyone, I am new to VB Script. Basically i m creating the graphs in the ppt and i want to select the chart sheet so that the graph is visible. Matters. Chart. Plot. Area do whatever to the plot area. End With Jon Jon Peltier, Microsoft Excel MVPTutorials and Custom Solutionshttp Peltier. Tech. comlt ahperezgmail. I am working to update the series source in a chart. I have an excel template in which I copy 2 worksheets into my workbook. I would like to edit one chart using my VBA code. I am getting Method Plot. Area of Object Chart Failed. The code is below. Thanks for your help. Sheets1. Select Active. Sheet. Chart. ObjectsWhat. Matters. Activate Active. Chart. Plot. Area. Excel 2. 01. 0 VBA Active. Chart. Set. Source. Data Failed. I have a Excel VBA application which has been working fine in Excel 2. Excel 2. 01. 0. The relative codes are Public Sub CreateChart. Dim Output. Text As String. Output. Text Output. Source. WorkbooksNew. Work. Book. Activate. With Active. Sheet. RangeData. Range. University Of Delaware Graduate Programs Psychology more. Number. Format 0. Active. Sheet. Chart. Objects1. Activate. Active. Chart. Chart. Area. Select. Active. Chart. Set. Source. Data Source obj. RangeData. Range. The error message appears when debugger hits Active. Chart. Set. Source. Data Source obj. NBR. RangeData. Range with this window. The Data. Range in debugger is F2 R2, F3 R3 with the obj pointing to the right Excel form. The the Active. Chart is from a template. My debugger shows Active. Chart. Chart. Area. Select is true. And Active. Chart and obj are valid objects. Most important is that Excel 2. I use the debugger to compare the Excel 2. Active. Chart. And I can not find much different in terms of codes. I do see my template for the Active. Chart is a bit different in 2. The original template is exactly the same as shown in 2. That is the only difference I can notice between 2. I am not sure that can cause this error. I am not sure whether I have missed any evidence. The error message does not give much details. Is there any other ways to get more debug infoI appreciate it if anyone can help me find the problems and fixes. Thanks in advance. Edit. 1 The obj is created in another routine and the Data. Range are populeted in that routine Workbooks. Add. My. Workbook Active. Workbook. Name. Set obj Active. Workbook. Worksheets1. Bangla Choti Pdf Bangla Font. And then the data is inserted to Data. Range cells F2 R2, F3 R3. I can see the Excel file shown with the correct data. Edit. 2 The WorkbooksNew. Work. Book in the above sub is generated from these codes and I can see the new Excel with the chart is shown on the screen WindowsDirTemplate. File. Activate. Active. Workbook. SheetsC1. Select. Active. Workbook. SheetsC1. Copy. New. Work. Book Active. Workbook. Name. WindowsNew. Work. Book. Visible True. Edit. 3 Use Sids approach to declare the object first in this way Public Sub CreateChart. Dim wb As Workbook. Dim ws As Worksheet. Dim obj. Chrt As Chart. Object. Dim Chrt As chart. Set wb WorkbooksNew. Work. Book. Set ws wb. Sheets1. Set obj. Chrt ws. Chart. Objects1. Set Chrt obj. Chrt. RangeData. Range. Number. Format 0. Chrt. Export c temptest. Chrt. gif. With obj. Page. Setup. Print. Area Data. Range. Zoom False. Fit. To. Pages. Tall 1. Fit. To. Pages. Wide 1. Orientation xl. Landscape. End With. Print. Out Copies 1. Chrt. Set. Source. Data Source obj. RangeData. Range. The error is exactly the same. Please notice that I have the commented out codes to print out and save the Chrt and obj. RangeData. Range objects. The values are the same as image 2 and image 3 in the above. So chart and data are there. I just wonder why Chrt. Set. Source. Data Source obj. RangeData. Range does not work in this case in 2.