How to Switch X and Y Axis in Excel (Flip Chart Axes) Knowing how to switch the x-axis and y-axis in Excel will save you a lot of trouble. Microsoft Excel is powerful spreadsheet software that will let you store data and make calculations on it. You can then visualize the data using [...]
How to Create a Box and Whisker Plot in Excel If you’re a stats person, a box and whisker plot must be your go-to chart 📈 That’s because this one chart accommodates most of the key statistical values for any dataset. Starting from quartiles to the median to the outliers of that dataset. [...]
With the release of Excel 2016, several new features were added. Among these 6 new charts! We've created an infographic, showcasing each of the new charts and how you can benefit from using them.
How to Use "For Loops" in Excel VBA: Step-by-Step In programming, loops allow you to run the same code multiple times. It’s simple, but it’s one of the most powerful things you can do with VBA. (And it saves you a huge amount of typing.) In this guide, I show you how to [...]
How to Use Tables in Excel Step-By-Step With Examples Not that you cannot get along in Excel without using tables – but if you yet don’t know what Excel tables are, you’re missing out on something very big 💥 Excel table is an amazing tool that will automate most of the operations that [...]
How to Highlight Every Other Row in Excel: Step-by-Step Highlighting every other (or alternate) row helps readability. Often when you have a pack of data with so many rows and columns, it gets hard to decipher the data. So how can you highlight rows in Excel? Manually? Yes, you can do that, but [...]
How to Add Error Bars in Excel: Step-by-Step With Examples It is really challenging to ensure 100% accuracy for all of our data points when we present data. In Excel charts, you can add error bars to reflect the degree of uncertainty in each data point. Luckily, adding and modifying error bars in [...]
How to Change Case in Excel to UPPER, lower, and Proper Sometimes, you need to change the letter case of a text for proper capitalization of names, places, and things. In Microsoft Word, it's easy to do that using the Change Case button. However, there is no Change Case button in Microsoft Excel [...]
How to Add and Change Headers/Footers in Excel Sheet Headers and footers in Excel are great for adding basic information to your worksheets such as page numbers, dates, or workbook names 😀 Adding headers or footers helps you add data without needing to change the data or format of your worksheet. This also [...]
How to Make a Scatter Plot in Excel (and When to Use It) A Scatter plot is one of the best tools for the visualization of data in Excel. It helps analyze trends and represent the relationship between two values more concisely. But how can you use it to display your data? We [...]