The following screen shot shows how to arrange the graph as stacked blocks.
The graphs shows four categories: "Stanzen,Biegen,Beschichten,Vormontage" and 10 stacked blocks. Each block is represented by a value, and the color of each block is different. In order to achieve this, the AutoFit property should be set to True, and the AllowMoveValue property should be set to 0x701 (exLeftClick(1), exDisableMoveCategory (0x100), exEnableMoveSerie (0x200), exEnableMoveData (0x400)). The CategoryAxis.Categories property should be set to "Stanzen,Biegen,Beschichten,Vormontage". The series should be defined as stacked series using exSerieStack(12) and the values of each block should be added to the series using the Add method. The color of each block can be set using the Color property.
The following code snippet shows how to do this:
With Graph1
.BeginUpdate
.AutoFit = True
.AllowMoveValue = AllowKeysEnum.exLeftClick Or AllowKeysEnum.exDisableMoveCategory Or AllowKeysEnum.exEnableMoveSerie Or AllowKeysEnum.exEnableMoveData
.CategoryAxis.Categories = "Stanzen,Biegen,Beschichten,Vormontage"
With .Series
.Def(exSerieStack) = "A"
.Def(exSerieShowValue) = 1
.Add("3.25").Color = RGB(91,148,201)
.Add("5.15").Color = RGB(238,127,48)
.Add("2.75").Color = RGB(167,167,167)
.Add(",3.35").Color = RGB(255,195,13)
.Add(",2.25").Color = RGB(69,116,208)
.Add(",,8.45").Color = RGB(112,173,70)
.Add(",,3.15").Color = RGB(34,96,143)
.Add(",,,4.35").Color = RGB(158,72,13)
.Add(",,,4.35").Color = RGB(99,99,99)
.Add(",,,2.65").Color = RGB(152,115,0)
End With
.EndUpdate
End With
The following points summarize how to define the graph as stacked blocks:
- Each Add("...") defines one block (one colored segment)
- The number in the string is the block's value (height). Use dot character as decimal separator, and use comma character to separate between categories and stacks.
- The commas at the beginning define the category (column):
- No comma means the first category (Stanzen)
- One comma means the second category (Biegen)
- Two commas means the third category (Beschichten)
- Three commas means the fourth category(Vormontage)
- All blocks are stacked because of: Def(exSerieStack) = "A"
- The color of each block is set with: .Color = RGB(...)
For instance, Add(",,3.15"), the first two commas indicates that the block is shown in the third category, stacked with block of Add(",,8.45"), and the value of the block is 3.15. The color of the block is set to RGB(34,96,143).