Renaming a numbered X axis category

[DashboardNovice]

In the attached file, I am plotting the change in dB. Column C represents the every instance of change. When I plot this, the X axis categories come out as 1, 2 and 3.

However, I want to start at 0 so that the category names are 0, 1 and 2. The reason being that 0 represents the initial value, rather than a change.

I tried to change column C to a Text format, but that didn't work. Is there a way to do this?

 

[vletm]

DashboardNovice
You seems missed to select xaxis ...

 

[DashboardNovice]

DashboardNovice
You seems missed to select xaxis ...
View attachment 68421

I think I've got it now. I selected all cells including the column names so that included the X axis. This resulted in 2 data series being plotted, so I deleted data series with the positive values (Change #). Then I did Select Data > Edit Horizontal Axis, then I selected the values under the Change # column. This worked.

How did you do this?

 

[vletm]

DashboardNovice
1) Activate You line
2) Select from formula bar as below

3) Select needed range ... until cell C10

4) Press <ENTER>