Wrapping to include data from next row

A

abarson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top