On 2002-11-07 11:50, Andrew Poulsom wrote:
Click on your chart and choose Tools, Options. On the Chart tab check "Not plotted (leave gaps)".
On 2002-11-07 11:49, RogerC wrote:
Speed - If I undersand you correctly, you should be able to do this fairly easily. Hold the Cntrl key down when making your data selection and use the mouse to select only the cells with data... skipping over the blank cells. You will get a chart that has no blank data categories.
On 2002-11-07 12:11, Andrew Poulsom wrote:
If your series data is in rows you can AutoFilter it for NonBlanks. Then the chart will only plot the visible cells.