Line Chart

Simmy1234

New Member
Joined
Mar 25, 2011
Messages
47
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
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
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.
 
Upvote 0

Forum statistics

Threads
1,224,502
Messages
6,179,126
Members
452,890
Latest member
Nikhil Ramesh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top