So the financial year in the model, runs from July to June. By default the model goes to the current FY and also displays the Period (YYYYMM).
In the chart - I always want to display all the months in the FY, by default - hence in the Set Analysis "Period=". But...the user can select a period because some of the other metrics on the sheet will update.
What happens now if you select a Period, is that the selected bar displays correctly, but all the others display in Black..which doesnt look great visually.
Please may you assist me - how can the "excluded" bars look less awful - grey would be great. (I load the colors from an Inline Load in the script)
