How-to Show Decades and Highlight a Year in the Horizontal Axis

4
Recently in an Excel Forum, a user had data similar to this format: Here is what he wanted to do:   How do I set the Horizontal...
Sample Displays of Excel Chart Dashboard Designs using Axis Groupings

Dashboard Design Examples – Excel Chart X-Axis Grouping

0
When Designing an Excel Company Dashboard you will want to make sure that your audience can easily read and interpret the data. Which do you...

How-to Make a Picklist Change the Chart Type for a Dynamic Excel Dashboard

4
Have you ever wanted to create a graph but then let users dynamically change the Excel chart type with a drop down pick list? ...

New Chart Label Leader Lines Available in Excel 2013

0
Did you know that you can now add Leader Lines to your Excel Charts in Excel 2013?  I didn't know this until just recently. ...

Friday Challenge – Eliminating outliers in and Excel Chart

4
Okay, apologies again .  I have been so swamped with my Go-Live project this week that I have been too tired to finish the...
Add a Target Line to a Clustered Stacked Column Chart

How-to Add Lines in an Excel Clustered Stacked Column Chart

2
I have posted several Excel chart samples related to Clustered Stacked Column Charts. In case you missed them, you can check them out here:   Excel...

How-to Show Gaps in a Line Chart When Using the Excel NA() Function

3
In last Friday’s challenge, we had a Excel Analyst that needed to remove outliers from his Excel Line Chart.  In essence, he wanted to...

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

How-to Create a New York Times Tiger Woods Chart in Excel

0
In a past article, I posted 2 different ways to make a chart that appeared in the New York Times.  Here is the chart...
Excel Dashboard Template Step-by-Step Tutorial and Sample File

Step-by-Step Tutorial: How-to: Make a Company and Industry P/E (Price to Earnings) Line Chart

1
In my last post I showed the concepts of making a P/E (Price-to-Earnings) Excel Chart for your Dashboard Template. In this post I will...
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