In a cell, there is a chart minimized to display data for two serries. Please see the attached image. They display data for 13 months.
The current month value stored in a named-range (CurrMthCol).
Is it possible to have a red line to show the location of the current month. The value of the current month will change and it is expected the location of the marker to shift as well per the value in CurrMthCol.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.