Tag: Excel
Customizing the Standard Excel Chart Titles
Titles on charts are not always necessary but when you use them, you will have many, many choices on formatting of which you may...
How-to Make Conditional Label Values in an Excel Stacked Column Chart
Recently I was thinking that sometimes when you make a Stacked Column Chart in your Excel Dashboard, you may want to hide some of...
What to Do When Formulas Don’t Work from an Exported Salesforce.com Report or CSV...
Recently during a Project that was using Salesforce.com,
I created a custom report and then exported the results to Excel. This report looked and...
How-to Fix an Excel 3D Chart so that it Matches the Gridlines
While working for a company that paid bonuses, the Financial and Human Resources team sent out a chart showing how close we are to...
Creating Excel Stacked Column Chart Label Leader Lines/Spines
In my last post, I showed you how to create a Brace/Curly Bracket/Mustache InfoGraphic type grouping in an Excel Stacked Column Chart.
You can check...
How-to Recreate a NYT InfoGraphic Mustache Grouping Chart in Excel
I love trying to create an Excel chart that was originally drawn with an Infographic software package. Back in 2011 I saw a New York...
Halloween Special – Spider Web, Spider and the Fly Chart
In honor of Halloween I thought I would post something fun. For those that are not in the USA, Halloween is where children dress...
The Best Way to Separate Address Text to Multiple Columns
I have been doing an excessive amount of data migration on my last assignment using Microsoft Excel. Typically I can do this so much...
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...
Incredible Excel 2012 Olympic Medal Count Dynamic and Interactive Dashboard
People are awesome and so creative. We have been talking about building an Olympic Medal Count Dashboard using Excel and I asked for your...
