The exact solution will depend on chart type. Review this discussion on "gaps" in charts: http://peltiertech.com/mind-the-gap-...g-empty-cells/