This TechTIP is a day late, as it is normally sent every other Wednesday, but I was attending the 2007 Electronics Distribution Show (EDS) in Las Vegas this week, and as they say, "what happens in LV, stays in LV..."

To make up for being late, this TechTIP is a 'twofer'; two One Minute TechTIPs.

Sometimes datapoints for a chart may be missing, because the data is unavailable or a calculation has not been completed and the chart will have breaks like those shown below in Example 1.  You may want to show those discontinuities, or you may prefer to have those breaks connected with a smooth line.  You can have those breaks connected by a smooth line as shown below in Example 2, by inserting =NA() in the cell with the missing data (manually, or programmatically and the data in the cell will be displayed as #N/A).  A visual clue that the 'breaks' have been filled-in by NA(), is that there will be no markers shown.

If you want multiple worksheets to be formatted to print exactly the same, don't format them one-at-a-time.   Here is a quick and easy way to format multiple worksheets simultaneously.  Hold down the Control key and click on each worksheet you wish to have formatted.  Now when you select File/Page Setup, the attributes you select will be applied to each worksheet simultaneously, i.e. margin, header and footer settings, all-at-once for each page!