Quantcast
Home Tags Tips and Tricks

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

0
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

18
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

0
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

4
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

2
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...

0
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. ...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link