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

[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

 

[Andy Pope]

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

 

[Heera]

thanks a lot it worked out...

I am so happy......thank you.