Cannot Activate Chart Area in Chart. Chart Object Failed

Posted to microsoft.public.excel.programming

Tony

external usenet poster

Posts: 1

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
need variable time axis available in XY chart for area chart	Byron	Charts and Charting in Excel	0	February 6th 10 03:58 PM
need variable time axis available in XY chart for area chart	Byron	Charts and Charting in Excel	0	February 6th 10 03:17 PM
how to remove dotted line with words chart area from around chart	desof	Charts and Charting in Excel	2	May 13th 09 10:18 PM
Paste Method of Worksheet Failed When Copying Chart Object	Larry[_3_]	Excel Discussion (Misc queries)	0	May 17th 07 11:02 PM
Have chart lines take up full area of chart from left to right	Roger[_20_]	Excel Programming	1	June 22nd 05 09:02 PM

All times are GMT +1. The time now is 05:25 PM.

Menu

About Us