May 12 2023 01:23 PM
Hi, I am attempting to recreate the attached graph, which can be seen on the CDC COVID data tackers wastewater surveillance section alongside a downloadable .csv. I know that it is a 100% stacked graph but I cannot figure out how to format the data correctly. Could really use some help.
May 12 2023 02:24 PM
It's a combination of a 100% Stacked Area chart and a Line Chart.
See the attached simplified demo workbook.