Quantcast

Case Study – Creating a Dynamic Chart in Excel Using Offset Formula

2
A YouTube video subscriber Mili, wanted to know more about creating a Dynamic Excel Column Chart using Offset function.  So Mili sent me the...
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...

Step-by-Step Horizontal Bar Chart with Vertical Lines Tutorial

6
In a recent request for help in the MrExcel Forums, a user was having difficulties adding Vertical Line KPI Metrics to a Horizontal Bar...

Add Multiple Percentages Above Column Chart or Stacked Column Chart

0
I recently posted a tutorial on how you can put a percentage at the top of a Stacked Column Chart.  You can see the...

Group Column Chart with Lines for Excel Dashboard Presentations

1
Yesterday a user in the MrExcel.com Forums asked how he could make a Column Chart in Excel and then Group those Columns with a...

How-to Format Chart Axis for Thousands or Millions

17
Here is a great way to make your Dashboard Charts in Excel more appealing and your boss will love you and your friends will...

How-to Make a Beer Mug Goal Chart as an Excel Dashboard Component

26
Time for some beer and Excel.  Last month I saw that a User was wondering how to make Beer Mug Goal Chart for their...

Using the Camera Tool to Create a Vertical Line Chart in Excel

1
Last week a user in the Mr. Excel Forum wanted to know how to make a vertical line chart where the horizontal categories are...

How-to Make a Tenant Timeline Excel Dashboard Chart

4
So last week, I posted this question that I responded to in an Excel forum.  I also asked you how you would solve this...

How-to Make a Conditional Column Chart in Excel

3
As you build your Microsoft Excel dashboards, you may want to highlight your data points that exceed your Key Performance Indicators (KPIs) as well...
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