Hi,

I'm working with a small program that outputs rows in a CSV in the following format: xvalue, yvalue, data_series_name

What is the best way to get Excel to graph this in (ideally) an area chart or (alternatively) in a scatter plot using the a common xy-plane but different colors for each data_series_name? I can't seem to get it right.

If there is a better way to visualize this, I have access to the source code of the program and can change in pretty much any way.

Thanks!