Not to show zero data in the chart
Currently I had created a data for Jan-Dec 06 which I cover the whole
data to create a chart.
The reason I cover the whole year data so that the info is automatic
updated in the charts whenever there is value in the particular month.(link from another book/worksheets
Is There any way not to show the Zero value data in the Charts without removing the formula as I need it to update if there is a value.
Anyone can assist or Have a better idea to do ?
A sample is enclosed
Video Tutorials / Excel Dashboards Reports