I’m trying to render a really simple graph using bubbles, on the first column I have the name of the bubble, then on the right cell X and then Y coordinates, the fourth column has the size value.
I have selected the area and specified it has data in lines, values of X and Y ranges between 0 and 255 while values of size ranges from 1 to 100.
I’m not able to show a correct graph, in fact when I switch to data series, it doesnt correctly assign X,Y and size to the relative cell of each entry, rather it assumes Y and size as ranges rather than a single cell, and just ignore my X giving no value at all.
What am I doing wrong?
2nd test: it seems that the graph needs contiguous data, so all x, all y then all sizes; in this example it did ok, ill now try to add a names column:
3rd test: now I have manually added the name column but this has no effect in coloring, it seems that like excell we could have more areas and for each more series so to proper coloring every entry like I want I should add multiple areas each one with one single entry, manually it seems, unless someone has a solution: