Help with chart x axis range

[scecilia]

Dear Community,

I am creating a simple line chart with some data. The x data range ha
13 columns ( 1 through 13) and this is how is presented in the chart'
x-axis. HOWEVER, I need these x values to be desplayed in the x axe
going from 0 through 12 (not 1-13), how can I change this? I trie
several things but none works.

I am attaching a .jpeg file so you can see what I am talking about.

Can you please help??

 

[Debra Dalgleish]

Above the data, insert a blank row, and enter the numbers 0-12
Create an XY(Scatter) chart from the data and heading row, using one of
the XY chart subtypes that includes a line.