ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Wrapping to include data from next row (https://www.excelbanter.com/excel-worksheet-functions/141037-wrapping-include-data-next-row.html)

abarson

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.



Barb Reinhardt

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