T Tererai Muridzo New Member Nov 25, 2017 #1 hi have data starting at 1951 ,however when i insert a scatter graph it starts analysing at 1940 .see attached ,how do i resolver this. Attachments chart.xlsx 13.8 KB · Views: 3
hi have data starting at 1951 ,however when i insert a scatter graph it starts analysing at 1940 .see attached ,how do i resolver this.
V vletm Excel Ninja Nov 25, 2017 #2 Tererai Muridzo You can set minimum value as You would like. Ps. Your data starts from 1950.
Hui Excel Ninja Staff member Nov 25, 2017 #3 To do what Vletm said: Select the chart Right click on the Horizontal Axis Select Format Axis Set the Minimum axis Bounds
To do what Vletm said: Select the chart Right click on the Horizontal Axis Select Format Axis Set the Minimum axis Bounds