Tag: Tips and Tricks
Fixing Your Excel Chart When the Multi-Level Category Label Option is Missing.
I am so happy to help my fans, and I saw a recent comment on an older posting of mine and I thought I...
How-to Easily Create a Step Chart in Excel
You might be asking yourself, “What is a Step Chart?”
You have probably seen one, but didn’t know that it is called a step chart.
Here...
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...
How-to Fake an Excel Chart Data Table
Fake an Excel Chart Data Table
Yesterday, I showed you how you can use the Horizontal Axis option of “Multi-level Category Labels” to create a...
How-to Concatenate Excel Column or Row Data Using Google Docs
Yesterday I demonstrated how to find and replace a hard return in an Excel spreadsheet. I presented the last topic before this one so...
How-to Make Excel Put Years as the Chart Horizontal Axis Categories
I saw this post in a forum yesterday and thought that everyone should know this. Lord knows that I didn’t know this until just...
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 WSJ Excel Pie Chart with Labels Both Inside and Outside
I thought it was a in last week’s USA Today, but looking at the picture I took more closely, it may have been produced...
Protecting Your Excel Charts and Dashboards with Array Formulas
Has this ever happened to you?
You have sent your Excel Dashboard to your executive team or perhaps you have your spreadsheet on a shared...
How-to Make a USA Today Pie Chart Graph – Replicating All Charts in USA...
I have been traveling very frequently for business as a Salesforce.com Software Consultant, so I spend a lot of time in hotel’s and airports. ...
