I’m on a version of Excel that seems to be nowhere to be found anywhere else on the internet, so I haven’t found any meaningful help so far. I need to create a chart with 3 series out of a single set of data. I haven’t been able to figure out how to properly make a chart how I want. In the attached image, I have 2 charts. I need to make the top one look like the bottom one and I don’t have the SLIGHTEST idea how to do it. I do need to keep the data in 3 separate series, unless there is a way to make a trendline for a specific portion of a single series. Any help is appreciated.

​I’m on a version of Excel that seems to be nowhere to be found anywhere else on the internet, so I haven’t found any meaningful help so far. I need to create a chart with 3 series out of a single set of data. I haven’t been able to figure out how to properly make a chart how I want. In the attached image, I have 2 charts. I need to make the top one look like the bottom one and I don’t have the SLIGHTEST idea how to do it. I do need to keep the data in 3 separate series, unless there is a way to make a trendline for a specific portion of a single series. Any help is appreciated.  Read More

​