0

enter image description hereChart currently

Hi all,

I have looked up several videos on YouTube but cannot find the specifics of what I am looking for. I am trying to adjust the chart so that it only shows the months selected. The months selected runs off a formula resulting in TRUE and the Forecast is then multiplied by this to give £££ or £0.

Does anyone know how to make this chart dynamic?

Thanks, Shea

I watched YouTube videos but the way my data is set up is different to every video. Not sure if what I want to do is achievable.

  • So have a set of cells to bring in the valid date range based on a starting point. Then chart from those cells. See https://stackoverflow.com/a/69077964/4961700, or this: https://stackoverflow.com/a/71870957/4961700 – Solar Mike Dec 15 '22 at 14:49

0 Answers0