| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
A third option, if the cells appear blank because a formula returns "",
change "" to NA() in the formula. The cell contains the #N/A error, but the points will be connected by the line. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ ET wrote: Jon, For the monthly data; spacing it evenly over 26 bi-monthly pay periods means a blank cell about every other cell. When this happens I cannot connect the data points with a line. Anyway to get around this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dual Axis stacked bar. | Charts and Charting in Excel | |||
| can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
| Part Number/Qty Consolidations | Excel Discussion (Misc queries) | |||
| Second X axis at top of chart? | Charts and Charting in Excel | |||
| Labels on Chart with Negative Value Axis | Charts and Charting in Excel | |||
Threaded Mode
