how to make a scatter plot in excel

Ready, Set, Scatter: How to Make a Scatter Plot in Excel

This article consists of all the basics of how to make a scatter plot in Excel. By using this guide, you will be able to generate your own plots as well as format them and add design features. Scatter plots, also known as scatter charts or XY scatter plots, are a powerful visualization tool for …

Read more

how to alphabetize in excel

How to Alphabetize in Excel: Fast & Simple

One of Excel’s most important features is the ability it gives users to quickly and easily sort through data. With this said, learning how to alphabetize in Excel is critical. If you are not familiar with this skill, don’t worry too much. We will go over alphabetizing lists of strings, ordering numerical values, standard alphabetization, …

Read more

how to make a drop down list in excel

The Drop Down Basics: How to Make a Drop Down List in Excel

This article shows you how to make a drop down list in excel. It provides two ways for you to quickly and easily make drop down lists in an Excel spreadsheet. You can follow the instructions to create a new drop down list that will help streamline efficiency when collecting information in your spreadsheet. A dropdown list …

Read more

Analysis ToolPak AddIn

Check the Analysis ToolPak Add-In in Excel 2003 [VBA Code]

I recently began using the NETWORKDAYS function in Excel 2007, yet my file was going to be widely used by people with Excel 2003 (both are Windows versions). The NETWORKDAYS function is a standard function in Excel 2007, but with 2003 you have to install the Analysis ToolPak, otherwise you get an error. The only …

Read more

Select a Column of Non-Sequential Data

In one of my posts on using VBA to select a column of data, I received a comment asking if the macro could be modified to select data like the screen shot you see to the left. This data is non-sequential and consequently the CurrentRegion property won’t work. The way around this is to select …

Read more

Microsoft Query Incompatible with Mac OS X Lion [Updated]

The other day I read an article on how to prepare my MacBook Pro for Lion, the new Mac OS X coming out this month, and discovered that any application that requires PowerPC is incompatible with Lion and will not work. See update at the end of this post. So I followed the instructions to …

Read more

International Short Date Formatting for the TEXT Function

I have an Excel workbook that is used in two different regions where the date format is entirely different, the US and the UK. At the top of a report worksheet I use a TEXT function to inform the user of the date range. Here’s what a US user sees: From: 6/6/2011 to 6/10/2011 Here …

Read more

Select One Column of Data with VBA

Let’s assume you aren’t using an Excel Table, List Object, or List for your data table and you want to select the data in only one column, which means the Header row is excluded. This can be simple if there’s data in every row of the column, but what if that’s not the case? And …

Read more

The Table Address and Structured Data in Excel

The data in an Excel Table is nicely addressed. Meaning when you ask Excel for the address of the Table you get the data only and not the Header row or, if toggled, the Total Row. The Table above starts in row 4 of the worksheet with a Header and ends in row 43 because …

Read more