G
Guest
I’m trying to convert arrays into bar graphs, but I haven’t found a way to
make the data range “wrap†from the end of one row and start at the next.
For instance, the array consists of 4 rows consisting 32 cells each. The
entire data range is A1-B16, but it is actually A1-D16 + B1-B16 + C1-C16 +
D1-D16, producing a continuous graph for all values 1-128, and the value in
each cell would indicate the height of the bar. Any tips as to how to
accomplish this would be greatly appreciated.
make the data range “wrap†from the end of one row and start at the next.
For instance, the array consists of 4 rows consisting 32 cells each. The
entire data range is A1-B16, but it is actually A1-D16 + B1-B16 + C1-C16 +
D1-D16, producing a continuous graph for all values 1-128, and the value in
each cell would indicate the height of the bar. Any tips as to how to
accomplish this would be greatly appreciated.