Quantcast
Home Tags How-to

Tag: How-to

How-to Add a Line to an Excel Chart Data Table and Not to the...

8
Many people making Excel charts love to add a Chart Data Table to their graph.  However, the Excel Data Tables are not very flexible...

Excel Line Charts Using a Date Axis

0
Not sure if you knew this or not, but Excel is amazing! The makers of Microsoft Excel even went so far as to make sure...

Problems Creating an Excel Open-High-Low-Close (Candle Stick) Stock Chart

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

Fastest Way to Open a New Workbook in Excel

0
I saw in a recent post on Contextures.com, that Excel 2013 has added new option that you can choose to not display the start...

How-to Connect Gaps in a Line Chart in Excel

7
When you are build your Excel Dashboard Template charts, you may find that some of your data is not complete.  For instance, you may...

How-to Create Sales Quota Threshold Horizontal Lines in an Excel Column Chart

6
Sales executives are always pushing their sales teams.  They typically do this by setting sales quota’s for their salespeople.  Quotas are thresholds or minimum...

How-to Make an Excel Area Chart Cliff (Fiscal Cliff Edition)

0
So all the US news agencies keep talking about the Fiscal Cliff.  This reminded me of a problem that many people have when making...

Grouping Excel Column Charts with a Box

0
In a previous post, I showed you how to group a column chart with lines: You can check out the posting here: Group Column Chart...

How-to Show Excel Chart Data and Keep Chart Size when Hiding Spreadsheet Columns and...

0
Many times when you are building your Excel Dashboard Templates, you will want to hide rows or columns in the same area as your...

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