Hi all,
I've read this post already on suppressing zeroes in bar charts but I still can't get this working.
The chart refers to data straight through FY2020 (and this data is fake) - as you can see, we only have actual data through 6/20. I need to suppress the #NAs beyond 6/20 (which represent forecast months) in the easiest way possible, but want new months to simply appear on the chart as new data comes in.
I don't want to create multiple series and would prefer the formatting approach, but it's not working. Can someone tell me step by step what to do? Do I need to format the labels in row 20? the data in rows 24-26? Do I change the formatting of the series in the charts? Etc.
Thank you!
Fowzee
I've read this post already on suppressing zeroes in bar charts but I still can't get this working.
The chart refers to data straight through FY2020 (and this data is fake) - as you can see, we only have actual data through 6/20. I need to suppress the #NAs beyond 6/20 (which represent forecast months) in the easiest way possible, but want new months to simply appear on the chart as new data comes in.
I don't want to create multiple series and would prefer the formatting approach, but it's not working. Can someone tell me step by step what to do? Do I need to format the labels in row 20? the data in rows 24-26? Do I change the formatting of the series in the charts? Etc.
Thank you!
Fowzee