My question is:
In one sheet I'm entering some date data in a1:a10. these cells are linked to another cells F1:F10 and made a line chart using the range F1:F10. But when a cell becomes blank in the data range (a1:a10) that cell data becoming as zero and corresponding date value is taken and chart shows wrong result. How can I keep the cell blank and chart shows a gap only while there's no data for an item?
Sherif Mannur
Bookmarks