Hi,
I'm trying to create a line chart that changes dynamically when I select months in the slicer for month. This line chart is part of the dashboard that I'm creating and it has many calculations. I encounter error whenever I click one month in the slicer but ironically, I don't encounter any issue when selecting multiple months in the slicer. I'm attaching the scaled-down version of the Excel dashboard in the post. See screenshot below:
Again, the line chart is part of the dashboard that I'm building and the end goal looks like in below screenshot:
I am using Excel 2016 for Mac and I used named range in the line chart so it can change dynamically with option to change the start and end date. I looked into the code and there doesn't seem to be anything wrong e.g. index, match, etc. I'm not sure why this annoying message keeps popping up and so appreciate if anyone can help. Perhaps, there is some simple solution that eliminates the error (something I might've overlooked as I've kept on working on this for so long) but of course, retaining all the intended functionality of the dashboard. Otherwise, let me know too if there are Excel limitations that I didn't know. I was also hoping to suppress the error popup message if it's possible because logically, nothing's wrong with the line chart.
Hope this makes sense.
Thank you in advance.
Washington