If there is no data i dont want the line to go down to 0%.

  • Thread starter Thread starter Heera
  • Start date Start date
H

Heera

Hi,

If i have some data in percentage month by month. In some of the
months i dont have any data.

In this condition if I draw a line graph the line goes down to 0% and
again it comes up which create a wrong picture in the mind.

Is there any way by which if there is no data for that particular
month it should directly get connected to the next month.

Regards

Heera
 
Hi,

If the cell is truly empty and the line drops to zero select the chart and
check,
Tools > Options > Chart > Plot empty cells as...

If the cell actually contain conditional formula use NA() instead of "" for
non data. This will interpolate the line but suppress the line marker.

Cheers
Andy
 
Back
Top