Quantcast
Home Tips and Tricks

Tips and Tricks

How-to Make an Excel Vertical Likert Line Chart with Categories

26
In the Mr. Excel forums there was a question raised on how can you create a Likert Chart or Graph using Excel.  The person...

Friday Challenge Answer – Find Unique Values from CSV List

Here is how you can quickly solve the most recent Friday Challenge: Find Unique Values from CSV List Before we begin, I am going to show...

Excel Clustered Column Chart Conundrum

Many, many, many Excel users post this problem in user forums.  And this one always throws me for a loop and takes me time...

Add Vertical Line Between Columns in Excel Stacked Column Chart

Add Vertical Line Between Columns in Excel Stacked Column Chart In this tutorial, you will learn how to QUICKLY add a vertical line between columns...

How-to Fix Security Links Warnings in an Excel Spreadsheet

If you have the yellow bar show up at the top of your Excel Spreadsheet "! Security Warning - Automatic update of links has...

The Tricks to Writing a Conditional Formatting Rule Formula

0
When you build your Excel Dashboard, you will frequently want to use Conditional Formatting to create color callouts and other table based dashboard components. ...
Non-Offset Chart Tip

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 From Overlapping the Columns When Moving a Data Series to the Second...

Don’t worry, Excel is not changing your chart to a Stacked Clustered Column Chart or Stacked Bar Chart when you move a data series...

How-to Fix a FRUSTRATINGLY Annoying Excel Scroll Lock Issue

Check out this simple technique if you have pressed the wrong keys on your keyboard and can't stop Excel from scrolling instead of moving...
Final Pivot Table Data Format

How-to Convert an Existing Excel Data Set to a Pivot Table Format

In previous posts, I have espoused the virtues of the Pivot Tables in Excel and that you should always think in terms of a...
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