Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Reference line for Clustered Column chart

Hi All,   I am trying to add a reference line after year 2020 in below clustered column chart to differentiate Past Present and Future values.   Y axis contains $ vale in year and X contains year...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Yes, I have tried line and stacked Chart but couldn't get the reference line after coloumn 2020.

moltra's avatar
moltra
Helper IV
6 years ago

Can you post a representative table of your data?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you for the reply.

     

    • moltra's avatar
      moltra
      Helper IV
      6 years ago

      can you post it as a table, so I can copy the data.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago
        YearNet Flow
        2005-111
        20062.89
        20074.7
        2008-33
        2009125
        2010270
        2011410
        2012422
        2013544
        2014455
        2015377
        2016154
        2017-45
        2018-136
        2019395
        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