| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| source data editor in Excel 2007 dont seem to allow copy and past. | Charts and Charting in Excel | |||
| graph, data lables value, dont show zero values | Charts and Charting in Excel | |||
| I have data in a time series that starts from 0 but i dont want x. | Charts and Charting in Excel | |||
| Want to choose last filled line, but dont know how? | Excel Worksheet Functions | |||
| x-axis dates dont match up with the nodes on the line graph | Charts and Charting in Excel | |||
Hybrid Mode
