I’m currently working on creating a dynamic chart which is updated monthly in accordance with the information imported into the excel file.
The table is updated with the information, where the chart is supposed to only show the current month based on a specific cell, shown in the attached excel file.
Example text “Period 01JAN18 0001 to 31JAN18 2259”
What the chart needs to do is match the text with a month, so if the text says “JAN” it’s supposed to grab the data for January, if it says “FEB” it’s supposed to grab the data for February.
Currently the chart shows the data for every single month, where I then have to filter out the current month and Year To Date.
I hope this explains it properly :)