![]() |
Wrapping to include data from next row
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. |
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. |
All times are GMT +1. The time now is 06:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com