Formatting different parts of line in Excel chart differently - Excel 2007
I recently had a query from someone asking how to format different parts of a line chart differently. Apparently they could do it in 2003 but couldn't see how to do it in 2007. First of all I didn't know that could be done in 2003 :-) so how would it be done in 2007. For example, the idea would be that part of the line would be in black, and then another part of the same line in yellow...