Hello! I'm trying to show multiple trend lines on a chart with what I think it some simple data. I can do it manually by selecting different data series for each category, but I'm looking for something that is easily updatable as new categories are added to the dataset.
The data I want to map is category, date, value. I've uploaded a sample spreadsheet.
Any tips? Thanks in advance!
Randy
