Hi All, I updated the formula series for around 10 rows which resulted as #NA for 6 rows and values for 4 rows. I updated fixed dates as x axis for all the ten rows. I need the chart which displays only those 4 rows. In future, if the #NA changed as value, the chart has to be updated automatically. Pls. help me on this
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Do not update x axis in the chart if the respective value is na()
- Thread starter Thanish
- Start date
Similar threads
- Question
