Shifting x-values in chart

[Abed Alnaif]

Hello, I have a line graph, and I am trying to shift it to the left by 5 units. For example, consider the following data set:

x: 5, 6, 7, 8, 9
y: 30, 54, 65, 79, 21

would become:

x: 0, 1, 2, 3, 4
y: 30, 54, 65, 79, 21

I know I can do this by modifying the source data in the spreadsheet, but I'd rather do this in the options of the chart. For example, is it possible to use formulas in the "Source Data" dialog box to shift the x values to the left by 5?

Thanks.

[Andy Pope]

Not within the chart. Charts just plot the data provided.

The simplest thing would be to use another set of cells where you change the values via formula.

Or if you don't want to use cells you could use a named formula. See attached.