The Absolute Quickest Ways to Make a New Chart in an Excel Spreadsheet
When creating my Microsoft Excel Dashboard Templates, I frequently create a chart to see how it would look and I don’t always keep them. ...
Problems Creating an Excel Open-High-Low-Close (Candle Stick) Stock Chart
Every time and I mean EVERY TIME that I go to create a Candle Stick Stock Chart in Excel (otherwise known as an Open-High-Low-Close...
How-to Quickly Find and Jump to the Right Worksheet Tab in Your Excel Workbook
As Excel users, we may create a spreadsheet with many many many worksheets (tabs at the bottom) within the workbook. However, if you create...
How-to Create a Dynamic Excel Chart of Last 3 Months Data Without Offset
Chart of Last 3 Months
If you wanted to create a dynamic Excel chart of last 3 months of your data but didn't know how to...
Stop Excel Overlapping Columns on Second Axis for 3 Series
We have learned how to Stop Excel Overlapping Columns in a few posts on the site. A reader had a follow-up question that I...
The Easiest Way to Copy An Excel Worksheet – (With Only One Click)
Frequently when working in Excel, I will need to copy an entire worksheet.
Copying an entire worksheet is particularly helpful when you are need to...
How-To Copy an Excel Chart on Same Worksheet with a New Data Reference
Many users in Excel spend time creating an awesome chart on a specific data set, then they want to use that chart on another...
How-to Make a Pass Fail Chart in Excel
Last week, I posed a Friday Challenge that was posted in a Q&A for Excel. Here it is:
*****************************************************************
Plotting a line graph to track build...
Excel Line Charts Using a Date Axis
Not sure if you knew this or not, but Excel is amazing!
The makers of Microsoft Excel even went so far as to make sure...
Find And Replace from a List of Multiple Emails in Excel without VBA
Find And Replace from a List of Multiple Emails in Excel without VBA
I had a recent request from a friend who needed to Find...
