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