Monthly Archives: October 2019

Microsoft Excel – Charts with missing values

If you create a line chart where there are blanks in the data, the resulting chart can look rather odd! On the Chart Design tab, click Select Data. From the Select Data Source dialog box, click Hidden and Empty Cells. … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | Leave a comment

Microsoft Excel – The UNIQUE function

If you are an Excel 365 user, you will have the UNIQUE function, which looks at a range of cells and produces a list of unique values. This may, be useful, for example, if you wanted to create a Data … Continue reading

Posted in Uncategorized | 2 Comments