Hello. I want to create a bar chart that takes all the months of a year and compares it fro two years. So, January would be "this year"/"prior year", etc, etc. And it wouldn't include bars for blank data.
If you provide us with a packaged workbook, we could try to give more specific help. Otherwise, these resources may help:
Current vs Previous Period to Date Comparison
Comparing 2 different periods on same data
Retrieving data ...