1) Pls attach your workbook.
2) Pls clarify: "I want each year that a user has opted in from 2003-2018 to be a color, so 2003 would be 1 solid color and 2018 would be 16 colors." So 2018 year should have 16 colours? Or one colour for one year?
Unfortunately because this is work related I can't publish the workbook so i understand if that limitation makes is hard or impossible to help.
I would like to see a bar graph from from 2010-2018 (i don't need prior 2010 now) that shows the count of new opt ins by year aggregated and look something similar to the below, but instead of being $ on the Y axis i want the aggregated distinct count of opt-ins.
So if 2010 was represented in blue and there were 100 opt ins, then the 2010 bar would be 1 solid blue bar and reach 100 opt-ins on the y axis. If 2011 was represented in yellow and there were 200 opt-ins, then the 2011 bar would reach 300 opt-ins on the Y axis and be split 1/3 blue, 2/3 yellow and continue this until 2018. Each bar should get bigger in size and aggregate the previous year(s) opt-ins.
Does this help?
Thank you, really appreciate the help!
Of course i forget about running total!