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

Thanish

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

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Watch MrExcel Video

Forum statistics

Threads
1,118,175
Messages
5,570,687
Members
412,336
Latest member
Tiffany927
Top