Various Graph data extraction help

%3CLINGO-SUB%20id%3D%22lingo-sub-2748772%22%20slang%3D%22en-US%22%3EVarious%20Graph%20data%20extraction%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2748772%22%20slang%3D%22en-US%22%3EHey%20guys%2C%20bit%20of%20an%20odd%20one%20here.%3CBR%20%2F%3E%3CBR%20%2F%3EBasically%20I%20have%20multiple%20different%20graph%20types%20on%20one%20excel%20spreadsheet%20and%20I%20need%20to%20extract%20the%20data%20from%20them%20to%20feed%20into%20another%20work%20sheet.%3CBR%20%2F%3EI%20used%20the%20macro%20Microsoft%20published%20to%20do%20with%20this%20and%20it%20worked%20BRILLIANTLY%20for%20the%20normal%20graphs%2C%20the%20problem%20is%20there%20are%20so%20many%20graph%20types%20and%20when%20I%20try%20run%20it%20i%20get%20an%20error%20saying%20%22object%20variable%20or%20With%20block%20variable%20not%20set%22%3CBR%20%2F%3EAny%20suggestions%20would%20go%20a%20long%20way%3CBR%20%2F%3E%3CBR%20%2F%3ECheers%3CBR%20%2F%3EEuan%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2748772%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
Hey guys, bit of an odd one here.

Basically I have multiple different graph types on one excel spreadsheet and I need to extract the data from them to feed into another work sheet.
I used the macro Microsoft published to do with this and it worked BRILLIANTLY for the normal graphs, the problem is there are so many graph types and when I try run it i get an error saying "object variable or With block variable not set"
Any suggestions would go a long way

Cheers
Euan
0 Replies