Combo Chart Line up

Occasional Contributor

I am trying to line up this data and create a combo clustered chart with a scatter plot. 

ea0428_0-1658171164374.png

Notice how the scatter plot does not exactly line up with the clustered column chart. 

 S&P 500 Intra Year Declines Total Return 
2002-33.0%-22.10%
2003-13.8%28.67%
2004-7.4%10.88%
2005-7.0%4.91%
2006-7.5%13.91%
2007-9.9%5.68%
2008-47.7%-37.00%
2009-27.2%26.45%
2010-15.6%15.06%
2011-18.6%2.11%
2012-9.6%14.22%
2013-5.6%32.37%
2014-7.3%13.67%
2015-12.0%1.37%
2016-10.3%11.95%
2017-2.6%20.79%
2018-19.4%-5.19%
2019-6.6%31.47%
2020-33.8%18.39%
2021-5.1%28.68%
2022-23.0%-19.97%

Wondering if there is a possible way to simply line up the dots

2 Replies

@ea0428 

I'd use a line chart with no lines, only markers. See the attached sample workbook.chart.png

A line chart combines with the columns better than the scatter in that both normally plot point mid-bay rather than on the grid points. Otherwise the column chart can be changed to plot on the grid points.