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

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

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

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Heera" wrote in message
...
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

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

thanks a lot it worked out...

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