Do not update x axis in the chart if the respective value is na()

Thanish

New Member
Joined
Oct 30, 2013
Messages
7
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
 

Forum statistics

Threads
1,082,639
Messages
5,366,708
Members
400,914
Latest member
anandkb

Some videos you may like

This Week's Hot Topics

Top