Excel – add a single point to a graph in excel

chartsmicrosoft excelmicrosoft-excel-2010

In Excel 2010, how do I graph a specific point on a graph that already has a line graphed on it. This specific point is from a different data set and does not fall on the line.

Best Answer

A "quick fix" might be simply to overlay a marker using Insert, Shapes (green diamond in example). Better would be to use a second "series" of data (brown square in example) so its position would adjust appropriately in response to changes in either axis:

SU517191 example

Related Question