Thread: Shifting x-values in chart

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.