Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to include ranges of data in a nested EXCEL formula | Excel Discussion (Misc queries) | |||
How to include data on the same sheet some in database some not | Excel Worksheet Functions | |||
In a pivot table, can the avg of a column include rows w/o data? | Excel Discussion (Misc queries) | |||
Data in Excel is not wrapping within cell consistently | Excel Discussion (Misc queries) | |||
Wrapping data in Excel | Excel Worksheet Functions |