Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot Activate Chart Area in Chart. Chart Object Failed
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 PlotArea of Object '_Chart' Failed. The code is below. Thanks for your help. Sheets(1).Select ActiveSheet.ChartObjects("WhatMatters").Activate ActiveChart.PlotArea.Select |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot Activate Chart Area in Chart. Chart Object Failed
1. If the chart has no data to plot, there may not be a plot area to select.
2. Don't keep selecting all the objects. It will be faster and less distracting this way: With ActiveSheet.ChartObjects("WhatMatters").Chart.Plot Area ' do whatever to the plot area End With - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ wrote in message ups.com... 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 PlotArea of Object '_Chart' Failed. The code is below. Thanks for your help. Sheets(1).Select ActiveSheet.ChartObjects("WhatMatters").Activate ActiveChart.PlotArea.Select |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot Activate Chart Area in Chart. Chart Object Failed
Thanks. I used your suggested code but now I am getting a 424 Object
required error. 'error here With ActiveSheet.ChartObjects("WhatMatters").Chart.Plot Area .SeriesCollection(1).XValues = "='" & managerDataSheet & "'!" & graphXValueAddress .SeriesCollection(1).Values = "='" & managerDataSheet & "'!" & completeGraphAddress End With Thoughts? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need variable time axis available in XY chart for area chart | Charts and Charting in Excel | |||
need variable time axis available in XY chart for area chart | Charts and Charting in Excel | |||
how to remove dotted line with words chart area from around chart | Charts and Charting in Excel | |||
Paste Method of Worksheet Failed When Copying Chart Object | Excel Discussion (Misc queries) | |||
Have chart lines take up full area of chart from left to right | Excel Programming |