Line Chart

[Simmy1234]

Hi

Please help, I got below information in three columns Year, Demand and Total Capacity

I need to show the number range on the horizontal axis starting at zero from 2009 and go up in yearly increments up until 2020.

Year Demand, 4% growth Total capacity
2009 36 513 40 506
2010 37 974 41 056
2011 39 492 41 211
2012 41 072 41 211
2013 42 715 43 137
2014 44 424 46 545
2015 46 201 48 933
2016 48 049 51 327
2017 49 971 52 127
2018 51 969 52 127
2019 54 048 52 127
2020 56 210 52 127

 

[Andrew Poulsom]

Right click the chart and choose Source Data. On the Series tab set the Category (x) axis labels to A2:A13. You might need to remove one of the series if that range is being plotted.

 

[Simmy1234]

Ngiyabonga (Thank you very much)