Charts
Dashboards
Features
Formulas

Charts

Skip Dates in Excel Charts

How do you create gaps on the horizontal axis of a line chart when the data values are empty - i.e. contain blank cells? Excel normally fills the empty dates on the x-axis and connects the line (where the gap should be). How do you avoid this? How do you skip dates in

  • excel dashboards charts leila gharani xelplus reports

Quick Gantt Chart

Create a Gantt Chart now in Excel with this step-by-step guide. Quick Gantt Chart A Gantt Chart is great for visualizing and presenting your project plan. But let's say, you just setup a preliminary project plan in Excel. You did that with the help of WORKDAY and NETWORKDAY functions. You

  • stacked column chart excel report

Stacked Column With Connectors

How do you create this chart in Excel? In this video you'll learn how to add series lines to stacked column charts. Instead of series lines, you might want to add a shaded background to each of the stacked sets. We can do that using stacked area chart and combine it with our

More

Dashboards

  • excel weekday pivot slicer

Excel Pivot Chart with Slicers

Get Weekday name from date and use Slicers Excel Pivot Chart with Slicers   Some reports require an interactive analysis of a large data set. In this example, we have a data set of daily closing prices as shown below: We want to create a chart that shows the average closing

  • excel chart dashboard

Excel Charts: Special Excel Graphs (InfoCharts)

How can you create this chart in Excel? The first time I saw a similar chart was in a report published by Udemy called Learning Trends & predictions in 2017. They used a similar chart to the one below (this one just has sample data though). I found the chart informative, visually effective and interesting.

5 Design Tips for Better Excel Dashboards

What results do you want to show in your Excel dashboard? What should readers take away from it? These five design tips will help you showcase your data clearly and directly. Scroll down for the video. Learn how to create this interactive Excel report in the upcoming ‘Visually Effective Excel Dashboards’ Course. 1.

More

Features

  • excel number format formula excel custom number format millions

Smart Uses of Custom Formatting

Use Custom Formatting instead of Conditional Formatting in Excel. Smart Uses of Custom Formatting We normally use custom formatting to show numbers with thousand separator, as percentage or even to show green for positive and red for negative values. But we hardly ever use custom formatting to show deviations with symbols.

Smart Uses of Custom Formatting – Part 2

Smart Uses of Custom Formatting - Part 2 Explore the possibilities of Custom Formatting with Part 2 of our guide. If you missed it, check out Part 1. CHAPTER 4: Any Symbol of your choice for Deviations Rather than insert a symbol as we did

  • Excel Table Design Report Dashboards

Excel Table Design

Use data tables when you want the reader to look up individual values and do exact one-to-one comparisons. Data tables are ideal for effectively presenting different types of data - such as costs, quantities, ratios, etc. - all in one place.   Let’s look at the best practices when designing tables. Organize Arrange your

More

Formulas

Complex Lookup: Find Header

Find Header based on Lookup Criteria in Matrix (Unique matrix values) - scroll down for non-unique method  In this tutorial I show you the answer to one of the questions that was asked some time ago on the Mr. Excel message board (the sample data was changed for the video) - The question

Lookup multiple criteria in rows or columns

The Complete Guide to INDEX & MATCH CHAPTER 2: Lookup multiple criteria in rows or columns Some reports involve the need to find a value from a source table using multiple criteria in rows and columns. In this example, we have a table containing both the actual and budget revenues and

  • Excel reverse lookup problem

Excel Reverse Matrix Lookup

Are you familiar with INDEX MATCH? If you're familiar with Index and Match you know how to solve a matrix lookup problem. You want to find a value inside the matrix by looking up the row and column headers. What happens though when it's reversed? You want to find the column header based

More
All Tutorials
Share This