Bar formatting in bar chart

QFanatic — Tue, 21 Dec 2021 21:56:36 GMT

Hi guys

Please find attached.

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)

Much appreciated.

Re: Bar formatting in bar chart

jwjackso — Wed, 05 May 2021 22:10:09 GMT

Check the "Background Color" formula for [Unit Rate]. If you comment out that code, the excluded values do not turn black.

Re: Bar formatting in bar chart

QFanatic — Thu, 06 May 2021 07:37:36 GMT

I cannot comment that part out.. The values on the stacked bar, are color
coded.

topic Re: Bar formatting in bar chart in App Development

Bar formatting in bar chart

Re: Bar formatting in bar chart

Re: Bar formatting in bar chart