| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
binding points in a line chart when having empty cells
Hi,
I need to make a linechart, but I do not have values in every cell in columns I am using. I would like the values I have to be binded together. Now they are binded if there are no emty cells between 2 points. I can not put in values in the empty cells, they have to be empty.. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
binding points in a line chart when having empty cells
Hi,
You can select the chart and use menus Tool Options Chart Plot empty cells: Interpolated. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Ksenija" wrote in message ... Hi, I need to make a linechart, but I do not have values in every cell in columns I am using. I would like the values I have to be binded together. Now they are binded if there are no emty cells between 2 points. I can not put in values in the empty cells, they have to be empty.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Labeling points on a line chart | Charts and Charting in Excel | |||
| I need to hide points on a line chart if the value is ZERO | Charts and Charting in Excel | |||
| Avoiding empty cells showing as zero in line chart without na() | Charts and Charting in Excel | |||
| Accessing Points in a Line Chart | Charts and Charting in Excel | |||
| Null points in a line chart | Excel Discussion (Misc queries) | |||
Linear Mode
