Chart cell should be showing a line. But is does not

Bugs
1

image
image1026×516 22.8 KB

image
image509×645 31.9 KB

A8 = [ “wk11”, “wk12”,

B8 = [1,3,6…

What is wrong? It is in my “sales weekly KPI” workspace. You can poke around there if needed.

NB: where is the undocumented Formula attribute for?

2

Hi @Folkerth we found the issue and fixed it.

image
image1267×400 19 KB

Basically there were 2 problems.

  1. In the Weekly X Axis cells (A8), you had a string for that array list of items. But it needed to be an actual array not a string. So we changed to be a formula.
  2. In the Chart, for the series values, you had B8 as the cell and it should be C8.

We only opened the record in Sheet mode and edited it. We didn’t actually change the template.

3

Great. Works like a charm!