Forum Discussion
Reference line for Clustered Column chart
Thank you for the reply.
can you post it as a table, so I can copy the data.
Year Net Flow 2005 -111 2006 2.89 2007 4.7 2008 -33 2009 125 2010 270 2011 410 2012 422 2013 544 2014 455 2015 377 2016 154 2017 -45 2018 -136 2019 395 2020 -527 2021 -777 2022 -980 2023 -1100 2024 -1336 2025 -1570 2026 -1780 2027 -1800 2028 -2103 2029 -2388 2030 -2400 2031 -2970 2032 -3100 2033 -3300 2034 -3590 2035 -3650 2036 -3900 2037 -4120 2038 -4300 2039 -5160 2040 -5371 2041 -5365 2042 -5464 2043 -6310 2044 -6,564 2045 -6,856 2046 -6900 2047 -7150 2048 -7330 2049 -7500 2050 -7680 I figured out one way of doing it, it is more a work around than anything, but you can create your normal clustered chart, and then create another clustered chart and have one data point in the table date: 2020 and net flow: -8000. you can then place the original chart in the back and place the 2nd chart on tom and then move to the correct position on the chart. You then shrink the chart as small as you can in width and place it over the 2020 date.
you also would need to turn off all the titles, and informtion for the 2nd table so they do not show up. If you turn off the responsive you can make the line thinner.
I am going to continue working on a more elegant solution, but if you like this answer then please accept this as the solution.