Weird Excel Charts

0
Have you ever seen a chart or graph like this in Excel? I created this chart using Excel the other day. It IS one combined chart using Excel. It is is NOT Two charts overlaid on top...

Excel Formulas: Average a Range and Ignore Zero’s (0 Value)

6
Excel formulas are a wonderful thing, but they may not provide all the flexibility you want when calculating information for your Executive Dashboard display.  Sometimes you need to make your own formulas when Excel...

Date and Time Series Issues in Excel Charts

11
Many users think they are getting an axis error when they say that their column or line charts are showing every date between data points, but all they want to show is the dates...

How-to Show All Formulas in Excel Spreadsheet

0
Have you ever wondered which cells have actual values entered and which ones are calculated formulas in your Excel spreadsheet?  Perhaps you are auditing a spreadsheet or checking your formulas and you need to...

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 as those data metrics that do not meet your KPI’s. ...

How-to Show All Named Ranges/Formulas in a List

2
In our previous posts we discussed how to build your dynamic Excel dashboard template charts by using an Offset formula and named ranges/formulas.  Then in our last post we showed you how-to quickly paste...

How-to Easily Paste a Defined Name in Chart Dialog Box

0
As you are learning to use Excel to develop your Executive Dashboard Templates, you will quickly learn that Defining Names are your friend. Defined names are great in saving time, and changing ranges in formulas...

How-to Copy Charts and Change References to New Worksheet

26
Have you ever made a great chart for your Excel Dashboard and you wanted to reuse it for another set of data?  Perhaps you want to recreate the chart for a new year or...

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 displayed vertically and then also wanted the vertical axis numbers...

How-to Format Chart Axis for Thousands or Millions

18
Here is a great way to make your Dashboard Charts in Excel more appealing and your boss will love you and your friends will envy your Extreme Spreadsheet knowledge. When you have really large numbers...