Quantcast

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

Friday Challenge – Step Chart for an Excel Time Series

I was recently asked for assistance with this request: Hi Steve, I am trying to make a hypnogram with data that we collected over the course...

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

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. ...
Clustered Stacked Column Chart by Month Year

Friday Challenge Answers: Year over Year Chart Comparisons

Thanks for the submissions for the Friday Challenge. You can get the sample data and chart request here:  friday-challenge-help-new-to-excel-yoy-comparisons   Here are some other submissions: A) In the...

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

How-to Make a Pass Fail Chart in Excel

Last week, I posed a Friday Challenge that was posted in a Q&A for Excel.  Here it is: ***************************************************************** Plotting a line graph to track build...

Friday Challenge: Excel Step Chart Automation

Yesterday, I posted the a demonstration on how to make a Step Chart in Excel. You can check out that post here: How-to Easily Create a...
Stacked Column Chart with 2 Axes

How-to Setup Your Excel Data for a Stacked Column Chart with a Secondary Axis

Many users have mixed reactions about this secondary axis overlap fix.  You can see the post here: Stop Excel From Overlapping the Columns When Moving...

How-to Draw a Straight Line with Excel Shapes

Have you ever tried to draw a straight line in Excel only to get frustrated? It can be so Frustrating :) to be off by...
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