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 that your charts will be plotted in the correct order...

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 graph) I run into an error.  It is very frustrating...

How-to Make a Basic Gantt Chart in an Excel Chart in 7 Easy Steps

6
Project Managers and Executives love Gantt Charts.  They also love Microsoft Excel, Charts and Graphs.  So it is a natural to consider how you too can make a Gantt Chart in Excel. Here is a...

Case Study Solution – Mom Needing Help on Science Fair Graphs/Charts

5
Yesterday I presented a case study on assisting a mom in creating a chart for a science fair. You can read more about it here: Case Study – Mom Needing Help on Science Fair Graphs/Charts So here...

Case Study – Mom Needing Help on Science Fair Graphs/Charts

0
I saw this posting on the ExcelForum site.  Please read it, copy it to Excel and give some thought on how you would handle this challenge.  Remember, a kid’s future is at stake .  ...

How-to Show an Apostrophe at the Beginning of a Text String in Excel

1
I saw that an Excel user was having a problem when creating his VBA code and you may run into this problem when you are trying to display text in your Excel Spreadsheet.  Here...

How-to Create an Excel Dashboard Column Chart with 2 Axis Groupings

0
Recently I saw this in the MrExcel Forums.  The title “Weird Charts with 3 Axis” intrigued me. I determined that they were looking to put the supplier names on the secondary horizontal axis descriptions (above...

How-to Create a Dynamic Banding on an Excel Line Chart

16
This dynamic shading or banding chart is frequently used in science and in Company Dashboards.  It allows the user to quickly see if their data is within tolerance or a specified range.  This can...

Things You Probably Didn’t Know About Excel

1
I am getting old .  We all are every second of the day . But,  my spreadsheet experience pre-dates Excel.  Time to take the WAY BACK MACHINE…………… WHAT, there was a spreadsheet system before Excel?  Why...

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 up screen that excel opens when you go to create...