Trend Analysis

[WaterLady]

For the life of me I can not figure out how to do a time series plot with a trend line of several parameters. Any thoughts? My data looks like this, I'm wondering if it being row based instead of column based. If so, any thoughts on how to easily convert it? It's about 2,000 rows so I don't want to do it manually.

Date	Parameter	Result
04-27-2000	Ammonia	0.05
04-27-2000	Nitrite	0.30
04-27-2000	Nitrate	0.006
04-27-2000	Kjeldahl nitrogen	0.58
04-27-2000	Orthophosphate	0.00
04-27-2000	Phosphorus	0.027
04-27-2000	Total suspended solids	1
04-27-2000	Chloride	19
04-27-2000	Total Nitrogen, mixed forms	0.886

[amitchandak · Accepted solution]

@WaterLady , One way is you can unpivot the Parameter column.

Another way is that you use that as legend along with slicer and limit no of line displayed