Forum Discussion
Reference line for Clustered Column chart
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.