Dynamic charting - please help - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Dynamic charting - please help

aminul_aliaminul_ali Posts: 1Member
Hello,

I am a newbie to VBA and i've been trying to figure out how to update a graph based on the current month/latest available data and then looking back six months in total. No luck! I looked at using defined names with functions, such as COUNTA, but as you'll see from the attached, there will be ref errors in there as the spreadsheet will draw new data every month from a different spreadsheet.

Please can anyone show me how I would do this using VBA or formulas?

Many thanks,

Aminul
Sign In or Register to comment.