Google Sheets Charts – How to Color or Group Same Kind of Data

The function VLOOKUP is only usable within a spreadsheet. This means that you use sheets !! Therefore I created a sample, based on sheets.

If you want to use spreadsheets however, then study the IMPORT function or Google Apps Script.

Remarks to the example:

1. I've created a table like the wiki page you included, with the calculated total. You can hide this sheet and lock it for updates, for anyone but you.
2. Pay attention to sheet 2, cell A11.
3. I've hidden rows 1 to 10 to make the autocomplete function to work.
4. See B1 in sheet 2, how it's done.

File I prepared with working example

Adding a sample of you own, helps a great deal to better understand what you mean !!

UPDATE: I've added edit rights to the example file I created, so you can play with it. Changed the names as well, each now being different (makes the auto-complete function work)

Stepped area chart does not support variable width of steps. But you can use the ordinary area chart like this:

The data provided to this chart was as follows. The first column was marked for "use as labels" when inserting the chart.

0.00    0
1.00    0
1.00    1
1.41    1
1.41    2
1.73    2
1.73    3
2.00    3
2.00    4
2.24    4
2.24    5
2.45    5
2.45    6
2.65    6
2.65    7
2.83    7

The idea is that each x value is repeated twice, and each y value is repeated twice, but they are half-step out of sync with each other. So every time we move down the rows, exactly one of two coordinates changes: x (horizontal segment) or y (vertical segment).

For the record, the formulas were =sqrt(floor(row()/2)) and =floor((row()-1)/2) and the chart options were