Tag: Format
Excel Formula Formatting Quick Tip
Excel Formula Formatting Quick Tip
Learn the best Excel Formula Formatting technique so that you can quickly edit them in the future! You will use...
My Excel Worksheet Only has 65000 Rows When Saving As Excel 2013 Workbook
So that everyone can use my Excel Charts and Dashboard Templates, I typically save my files in an Excel 97-2003 format. There are other...
The Quickest Way to Select an Data Series in an Excel Chart
In a previous post, I showed you how to get around a frustration that many Excel users have when creating an Excel Dashboard chart. ...
How-to Make a Non-Chart Excel Dashboard Chart (Heat Index)
So I saw this chart in an Excel forum and a user was asking this:
“chart - not sure about this one
I've created a...
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 Make a Wall Street Journal Horizontal Panel Chart in Excel
In a recent Wall Street Journal article I saw the following chart regarding Dropbox, YouSendIt and Box.com. The graph describes how many people use...
Add % Difference Data Labels to Excel Horizontal Tornado Chart
Okay, the client is always requesting changes. How do you deal with these? I suggest increasing the contracted hours. In this case, I decided...
Excel Line Break/Hard Return within a Cell
Most people don't know that you can put a Hard Return (Line Break) within a cell because when they hit enter Excel takes them to...
