Good day,
I've been creating dynamic charts when the data is input the chat updates with the months which I have got my head around. However, what I need to work out now is if you can have a dynamic chart with formulas.
for example I have a raw data file, and there are formulas in a table that once this data file is updated the tables does too.
however, because there is a formula in the blank months the dynamic chart still adds the month in.
Is there a way around this?
I've been creating dynamic charts when the data is input the chat updates with the months which I have got my head around. However, what I need to work out now is if you can have a dynamic chart with formulas.
for example I have a raw data file, and there are formulas in a table that once this data file is updated the tables does too.
however, because there is a formula in the blank months the dynamic chart still adds the month in.
Is there a way around this?