Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Dynamic charting - please help
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?