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
Conditional formatting is evaluated for each cell in the range, relative to the upper left cell in the selection. In this case, the formula uses the MOD function to check the remainder of dividing the value in each cell, with the value in cell E2, which is 9. When the remainder is zero, we know...Read more
In this article, we explain how to use concatenation to display friendly and useful messages in your spreadsheets. The messages are dynamic and respond instantly to changes, so the effect is polished and professional.Read more