Need help replicating a 100% stacked column from CDC

Copper Contributor

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. 


Percent of sites in each percent change category over time, United States (2).png

1 Reply


It's a combination of a 100% Stacked Area chart and a Line Chart.

See the attached simplified demo workbook.