Wrapping to include data from next row
You may need to have 4 different series and then format them the same.
"abarson" wrote:
Im trying to convert arrays into bar graphs, but I havent 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.
|