The default behavior of the MATCH function is to match the "next smallest" value in a list that's sorted in ascending order. Essentially, MATCH moves forward in the list until it encounters a value larger than the lookup value, then drops back to the previous value.
So, when lookup...Read more
This chart shows actuals so far in a solid line with forecast numbers in a dashed line. The chart type is set to line chart, and actual and forecast values are plotted as two data series. The data used for the chart is set up as shown below:
Combo charts combine more than one Excel chart type in the same chart. One way you can use a combo chart is to show actual values in columns together with a line that shows a goal or target value. In the chart shown in this example, daily sales are plotted in columns, and a line shows target sales of $500 per day.
I ran into this chart while looking for examples of XY scatter plots and couldn't resist re-building it, following the instructions outlined way back in 2000 I think. Unfortunately the original link no longer works.
The exercise is to verify the value of pi by plotting the circumference vs. radius of a number of objects measured in a lab. Here is the data:
I first saw a reference to this data on the interesting News, in Data site. The data cited comes from the drugabuse.gov website, and is presented in a combo chart with columns showing overall heroin deaths and lines showing the male and female breakdown. As the site says, from 2002 to 2015 there was a 6.2-fold increase in the total number of deaths. Here's one of the original charts:
I first saw a link to this chart on Politico. The original chart is a clustered column chart, but I though it would be interesting to show the data in a stacked bar chart instead. Stacked bar charts make it a lot easier to compare bar lengths. Here's the original:
This formula uses the EXACT formula to compare a range of cells to a single value:
=EXACT(B5:F5,B5)
Because we give EXACT a range of values in the first argument, we get back an array result containing TRUE FALSE values:
...Read more
In this example, the goal is to determine the position of the nth occurrence of a specific character (delimiter) in the text strings in column B. This article explains two approaches:
In this example, the goal is to average the last n columns in a set of data, where n is a variable entered in cell K5 that can be changed at any time. Since more data may be added, a key requirement is to average amounts by position....Read more