===================================================================
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
Index: PositioningSystem [LV2021]/PositioningSystem.vi
===================================================================
diff --git a/PositioningSystem [LV2021]/PositioningSystem.vi b/PositioningSystem [LV2021]/PositioningSystem.vi
--- a/PositioningSystem [LV2021]/PositioningSystem.vi (revision 34)
+++ b/PositioningSystem [LV2021]/PositioningSystem.vi (revision 35)
Index: PositioningSystem [LV2021]/class_EHF1/class_EHF1.lvclass
===================================================================
diff --git a/PositioningSystem [LV2021]/class_EHF1/class_EHF1.lvclass b/PositioningSystem [LV2021]/class_EHF1/class_EHF1.lvclass
--- a/PositioningSystem [LV2021]/class_EHF1/class_EHF1.lvclass (revision 34)
+++ b/PositioningSystem [LV2021]/class_EHF1/class_EHF1.lvclass (revision 35)
@@ -440,7 +440,7 @@
false
1
1
- 1074274832
+ 1082139152
-
===================================================================
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
Index: PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_MeasureDC.vi
===================================================================
diff --git a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_MeasureDC.vi b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_MeasureDC.vi
--- a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_MeasureDC.vi (revision 34)
+++ b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_MeasureDC.vi (revision 35)
===================================================================
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
Index: PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_MeasureNetworkAnalyser.vi
===================================================================
diff --git a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_MeasureNetworkAnalyser.vi b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_MeasureNetworkAnalyser.vi
--- a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_MeasureNetworkAnalyser.vi (revision 34)
+++ b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_MeasureNetworkAnalyser.vi (revision 35)
===================================================================
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
Index: PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_ResistanceForceDistance.vi
===================================================================
diff --git a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_ResistanceForceDistance.vi b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_ResistanceForceDistance.vi
--- a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_ResistanceForceDistance.vi (revision 34)
+++ b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_ResistanceForceDistance.vi (revision 35)
===================================================================
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
Index: PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_VisualizeHFMeasurement.vi
===================================================================
diff --git a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_VisualizeHFMeasurement.vi b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_VisualizeHFMeasurement.vi
--- a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_VisualizeHFMeasurement.vi (revision 34)
+++ b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_VisualizeHFMeasurement.vi (revision 35)
===================================================================
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
Index: PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/NetworkAnalyser_GetData.vi
===================================================================
diff --git a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/NetworkAnalyser_GetData.vi b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/NetworkAnalyser_GetData.vi
--- a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/NetworkAnalyser_GetData.vi (revision 34)
+++ b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/NetworkAnalyser_GetData.vi (revision 35)
===================================================================
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
Index: PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Test.vi
===================================================================
diff --git a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Test.vi b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Test.vi
--- a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Test.vi (revision 34)
+++ b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Test.vi (revision 35)
===================================================================
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
Index: PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization.vi
===================================================================
diff --git a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization.vi b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization.vi
--- a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization.vi (revision 34)
+++ b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization.vi (revision 35)
===================================================================
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
Index: PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization_Init.vi
===================================================================
diff --git a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization_Init.vi b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization_Init.vi
--- a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization_Init.vi (revision 34)
+++ b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization_Init.vi (revision 35)
===================================================================
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
Index: PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization_Limits.vi
===================================================================
diff --git a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization_Limits.vi b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization_Limits.vi
--- a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization_Limits.vi (revision 34)
+++ b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization_Limits.vi (revision 35)
===================================================================
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
Index: PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/WriteHFToExcel.vi
===================================================================
diff --git a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/WriteHFToExcel.vi b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/WriteHFToExcel.vi
--- a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/WriteHFToExcel.vi (revision 34)
+++ b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/WriteHFToExcel.vi (revision 35)
Index: PositioningSystem [LV2021]/class_PositioningSystem/class_PositioningSystem.lvclass
===================================================================
diff --git a/PositioningSystem [LV2021]/class_PositioningSystem/class_PositioningSystem.lvclass b/PositioningSystem [LV2021]/class_PositioningSystem/class_PositioningSystem.lvclass
--- a/PositioningSystem [LV2021]/class_PositioningSystem/class_PositioningSystem.lvclass (revision 34)
+++ b/PositioningSystem [LV2021]/class_PositioningSystem/class_PositioningSystem.lvclass (revision 35)
@@ -1009,7 +1009,7 @@
true
1
1
- 1342972432
+ 1342710291
-
)1#!!!!!!!)!"1!&!!!-!%!!!@````]!!!!"!!%!!!%.!!!!#!!-1#%'=X2B>(6T!!!,1!-!"'.P:'5!!""!-0````]'=W^V=G.F!!!71&!!!Q!!!!%!!AFF=H*P=C"P>81!"!!!!&"!=!!?!!!B(W.M98.T8V"P=WFU;7^O;7ZH5XFT>'6N,GRW9WRB=X-!*7.I;7RE9WRB=X.@5'^T;82J<WZJ<G>6<GFU,GRW9WRB=X-A37Y!)%"1!!-!!!!"!!)4:8*S<X)A;7YA+'ZP)'6S=G^S+1"5!0!!$!!$!!1!"!!%!!1!"!!%!!5!"A!%!!1!"!-!!(A!!!U)!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!3!!!!#A!!!!!!!!!!!!!!!!!!!!!"!!=!!!!!
@@ -1413,7 +1413,7 @@
true
1
1
- 1115685394
+ 1115685392
-
)1#!!!!!!!)!"1!&!!!-!%!!!@````]!!!!"!!%!!!$R!!!!#!!-1#%'=X2B>(6T!!!,1!-!"'.P:'5!!""!-0````]'=W^V=G.F!!!71&!!!Q!!!!%!!AFF=H*P=C"P>81!"!!!!$2!=!!?!!!B(W.M98.T8V"P=WFU;7^O;7ZH5XFT>'6N,GRW9WRB=X-!#%.M98.T)%FO!!!A1&!!!Q!!!!%!!B.F=H*P=C"J<C!I<G]A:8*S<X)J!&1!]!!-!!-!"!!%!!1!"!!%!!1!"1!'!!1!"!!%!Q!!?!!!$1A!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!"!!!!!+!!!!!!!!!!!!!!!!!!!!!!%!"Q!!!!!
@@ -1422,7 +1422,7 @@
true
1
1
- 1082139154
+ 1082139152
-
)1#!!!!!!!)!"1!&!!!-!%!!!@````]!!!!"!!%!!!'\!!!!$A!-1#%'=X2B>(6T!!!,1!-!"'.P:'5!!""!-0````]'=W^V=G.F!!!71&!!!Q!!!!%!!AFF=H*P=C"P>81!"!!!!!N!#A!&18BJ=T%!#U!+!!6"?'FT-A!,1!I!"5&Y;8-T!&A!]1!!!!!!!!!#(W.M98.T8V"P=WFU;7^O;7ZH5XFT>'6N,GRW9WRB=X-.9V"P=WFU;7^O,G.U<!!C1&!!!Q!&!!9!"R"D1X6S=G6O>&"P=WFU;7^O!!!11#%+47&O>7&M47^E:1!!.%"Q!"Y!!#%@9WRB=X.@5'^T;82J<WZJ<G>4?8.U:7UO<(:D<'&T=Q!*1WRB=X-A4X6U!$2!=!!?!!!B(W.M98.T8V"P=WFU;7^O;7ZH5XFT>'6N,GRW9WRB=X-!#%.M98.T)%FO!!!A1&!!!Q!!!!%!!B.F=H*P=C"J<C!I<G]A:8*S<X)J!'%!]!!-!!-!"!!)!!E!"!!+!!1!#Q!-!!1!"!!%!Q!!?!!!$1A!!!!!!!!*!!!!#1!!!!!!!!!."Q!!!!!!!")!!!!+!!!!!!!!!!!!!!!!!!!.!!!!!!!)!!!!!!!!!!!"!!U!!!!!
@@ -1431,7 +1431,7 @@
true
1
1
- 1115685394
+ 1115685392
-
)1#!!!!!!!)!"1!&!!!-!%!!!@````]!!!!"!!%!!!%S!!!!#1!-1#%'=X2B>(6T!!!,1!-!"'.P:'5!!""!-0````]'=W^V=G.F!!!71&!!!Q!!!!%!!AFF=H*P=C"P>81!"!!!!$2!=!!?!!!B(W.M98.T8V"P=WFU;7^O;7ZH5XFT>'6N,GRW9WRB=X-!#5.M98.T)%^V>!!U1(!!(A!!)2^D<'&T=V^1<X.J>'FP<GFO:V.Z=X2F<3ZM>G.M98.T!!B$<'&T=S"*<A!!)%"1!!-!!!!"!!)4:8*S<X)A;7YA+'ZP)'6S=G^S+1"B!0!!$!!$!!1!"!!%!!1!"1!%!!9!"Q!%!!1!"!-!!(A!!!U)!!!!!!!!!!!!!!!!!!!!!!!!$1=!!!!!!!!3!!!!#A!!!!!!!!!!!!!!!!!!$1!!!!!!#!!!!!!!!!!!!1!)!!!!!!
@@ -1449,7 +1449,7 @@
true
1
1
- 1115685394
+ 1115685392
-
@@ -1479,7 +1479,7 @@
true
1
1
- 1115685394
+ 1115685392
-
)1#!!!!!!!)!"1!&!!!-!%!!!@````]!!!!"!!%!!!%8!!!!#1!-1#%'=X2B>(6T!!!,1!-!"'.P:'5!!""!-0````]'=W^V=G.F!!!71&!!!Q!!!!%!!AFF=H*P=C"P>81!"!!!!#"!5!!$!!!!!1!#%W6S=G^S)'FO)#BO<S"F=H*P=CE!#U!(!!25;7VF!!"0!0%!!!!!!!!!!B^D<'&T=V^1<X.J>'FP<GFO:V.Z=X2F<3ZM>G.M98.T$G.4>'6Q2'6M98EO9X2M!"B!5!!"!!9+9V.U:8"%:7RB?1!!6!$Q!!Q!!Q!%!!1!"!!%!!1!"!!%!!5!"!!%!!=$!!"Y!!!.#!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!I!!!!!!!!!!!!!!"!!!!!!!1!)!!!!!!
@@ -1497,7 +1497,7 @@
true
1
1
- 1115685394
+ 1115685392
-
)1#!!!!!!!)!"1!&!!!-!%!!!@````]!!!!"!!%!!!4]!!!!-1!-1#%'=X2B>(6T!!!,1!-!"'.P:'5!!""!-0````]'=W^V=G.F!!!71&!!!Q!!!!%!!AFF=H*P=C"P>81!&E!S`````QVB=("F<G2F:#"Q982I!!Q!1!!"`````Q!%!!A!5!!"!!5!%E"!!!(`````!!9&2GFM:8-!%U!$!!V-<W&E1XFD<'5A4X6U!">!!Q!1476B=X6S:7VF<H2T)%^V>!!!"1!+!!!51(!!#!!"!!I!%A!!"5&Y;8-T!":!1!!"`````Q!,#%&Y:8.3:7:T!!!U1(!!(A!!)2^D<'&T=V^1<X.J>'FP<GFO:V.Z=X2F<3ZM>G.M98.T!!F$<'&T=S"0>81!$E!S`````Q21982I!!!U1(!!(A!!)2^D<'&T=V^1<X.J>'FP<GFO:V.Z=X2F<3ZM>G.M98.T!!B$<'&T=S"*<A!!)%"1!!-!!!!"!!)4:8*S<X)A;7YA+'ZP)'6S=G^S+1!/1$$`````"&6T:8)!!""!-0````]'6'6T>%F%!!!21!-!#F2F=X2/>7VC:8)!!""!-0````](1W^N<76O>!!21!9!#E:P=G.F4'FN;81!!">!#A!22G^S9W6-;7VJ>&:P<(2B:W5!$U!+!!B7:7RP9WFU?1!!%U!+!!R"9W.F<'6S982J<WY!!!N!#A!%3G6S;Q!!%5!+!!J*<GFU8U&Y;8-R!!!21!I!#EFO;82@18BJ=T)!!"&!#A!+37ZJ>&^"?'FT-Q!!'%!Q`````QZ5:8.U5H6O1W^N<76O>!!!9!$R!!!!!!!!!!)@9WRB=X.@5'^T;82J<WZJ<G>4?8.U:7UO<(:D<'&T=QFD6'6T>#ZD>'Q!,E"1!!U!%1!3!"-!&!!6!"9!&Q!9!"E!'A!<!"Q!(1FD6'6T>%2B>'%!%U!$!!R.:7&T>8*F<76O>(-!!"&!!Q!+4'^B:%.Z9WRF)!!!#U!$!!6*<G2F?!!31%!!!@````]!"!6';7RF=Q!)!&!!!1!C!"*!1!!"`````Q!D"5:J<'6T!":!5!!%!"]!)!!B!#1(2'&U93"*<A">!0%!!!!!!!!!!B^D<'&T=V^1<X.J>'FP<GFO:V.Z=X2F<3ZM>G.M98.T&'..<X:J<G>198*B<76U:8)O9X2M!#"!5!!$!"=!'!!:$UVP>GFO:V"B=G&N:82F=A!71#%2476B=X6S:6*F=WFT>'&O9W5!&U!'!"&3:8.J=X2B<G.F1WBB<GZF<!!31#%-476B=X6S:5:P=G.F!!!91%!!!P``````````!!I'47&U=GFY!!!)!$$`````!#*!1!!#``````````]!+R".982S;8B(:7ZF=G&U;7^O!!!<1!9!&%VB>(*J?%>F<G6S982J<WZ5?8"F!!!81!9!%%RP972$;'&O:W60=(2J<WY!!'M!]1!!!!!!!!!#(W.M98.T8V"P=WFU;7^O;7ZH5XFT>'6N,GRW9WRB=X-59V.U:8".:7&T>8*F<76O>#ZD>'Q!,E"1!!E!*A!H!#A!+1!K!"1!,!!N!#Y19V.U:8".:7&T>8*F<76O>!!!91$Q!!Q!!Q!(!!A!#1!-!!U!$A!0!"!!(A!F!#]$!!"Y!!!.#!!!#1!!!!E!!!!*!!!#%!!!!!U(!!!1!!!!%A!!!!I!!!!1!!!!%!!!!"!!!!U!!!!!!!A!!!!!!!!!!!%!-!!!!!!
@@ -1605,7 +1605,7 @@
true
1
1
- 1115685394
+ 1115685392
-
)1#!!!!!!!)!"1!&!!!-!%!!!@````]!!!!"!!%!!!%(!!!!#1!%!!!!%%!B#V.F>&"P=WFU;7^O!".!#A!-5'^T;82J<WYA4X6U!!!+1#%%37ZJ>!!!#5!+!!..98A!$U!+!!F%:8:J982J<WY!51$R!!!!!!!!!!)@9WRB=X.@5'^T;82J<WZJ<G>4?8.U:7UO<(:D<'&T=R&F2'FT>(*J9H6U;7^O,G.U<!!81!9!$%2J=X2S;7*V>'FP<A!!%5!+!!N1<X.J>'FP<C"*<A"5!0!!$!!!!!!!!1!#!!!!!!!!!!-!"!!&!!9!"Q-!!(A!!!!!!!!!!!!!#1!!!!E!!!!!!!!!!!!!!!!!!!!1!!!!%!!!!!A!!!!1!!!!%!!!!!!"!!A!!!!!
@@ -1669,7 +1669,7 @@
true
1
1
- 1115685394
+ 1115685392
-
)1#!!!!!!!)!"1!&!!!-!%!!!@````]!!!!"!!%!!!)@!!!!$Q!-1#%'=X2B>(6T!!!,1!-!"'.P:'5!!""!-0````]'=W^V=G.F!!!71&!!!Q!!!!%!!AFF=H*P=C"P>81!"!!!!!N!#A!&18BJ=T%!#U!+!!6"?'FT-A!,1!I!"5&Y;8-T!&!!]1!!!!!!!!!#(W.M98.T8V"P=WFU;7^O;7ZH5XFT>'6N,GRW9WRB=X-.9V"P=WFU;7^O,G.U<!!;1&!!!Q!&!!9!"QB1<X.J>'FP<A!!)%"1!!-!!!!"!!)4:8*S<X)A;7YA+'ZP)'6S=G^S+1!-1#%'23V4>'^Q!!!&!!I!!"J!1!!#``````````]!#QF*<H.F>%2B>'%!RA$R!!!!!!!!!!)@9WRB=X.@5'^T;82J<WZJ<G>4?8.U:7UO<(:D<'&T=RJF4'6B=GZJ<G>#>82U<WZT4X"U;7^O,G.U<!#$1"9!#!J%;8.B9GRF17RM$52J=W&C<'6.<X:J<G='27ZB9GRF$5.I:7.L5G6M982J>G5-5WBP>V*F<'&U;8:F$%BJ:'63:7RB>'FW:1N4;'^X476B=X6S:1N);72F476B=X6S:1!7:5RF98*O;7ZH1H6U>'^O=U^Q>'FP<A!!6!$Q!!Q!!Q!%!!1!"!!%!!1!"!!)!!E!#A!-!!U$!!"Y!!!.#!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!#!!!!!I!!!!+!!!##!!!!"!!!!!!!1!/!!!!!!
@@ -1912,7 +1912,7 @@
true
1
1
- 1115685394
+ 1115685392
-
)1#!!!!!!!)!"1!&!!!-!%!!!@````]!!!!"!!%!!!%H!!!!$Q!-1#%'=X2B>(6T!!!,1!-!"'.P:'5!!""!-0````]'=W^V=G.F!!!71&!!!Q!!!!%!!AFF=H*P=C"P>81!"!!!!""!-0````]'5X2S;7ZH!!!31%!!!@````]!"16/97VF=Q!A1&!!!Q!!!!%!!B.F=H*P=C"J<C!I<G]A:8*S<X)J!"*!-P````])6'6N='RB>'5!!!>!#A!"7!!(1!I!!6E!#A"1!!)!#1!+!""!1!!"`````Q!,!FB:!!!/1$,`````"&"B>'A!!&1!]!!-!!-!"!!%!!1!"!!%!!9!"!!(!!A!$!!.!Q!!?!!!$1A!!!!!!!!!!!!!!!!!!!!!!!!!!!!#%!!!!!!!!!!+!!!!%!!!!B!!!!!1!!!!!!%!$A!!!!!
===================================================================
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
Index: builds/PositioningSystem.exe
===================================================================
diff --git a/builds/PositioningSystem.exe b/builds/PositioningSystem.exe
--- a/builds/PositioningSystem.exe (revision 34)
+++ b/builds/PositioningSystem.exe (revision 35)
Index: support/ReportTemplates/Macro.bas
===================================================================
diff --git a/support/ReportTemplates/Macro.bas b/support/ReportTemplates/Macro.bas
--- a/support/ReportTemplates/Macro.bas (revision 34)
+++ b/support/ReportTemplates/Macro.bas (revision 35)
@@ -453,7 +453,6 @@
' 7) Diagramme für die HF-Messung
' =========================================
Sub AktualisiereXYDiagrammHF()
-
Dim datenWs As Worksheet
Dim diagrammWs As Worksheet
Dim chartObj As ChartObject
@@ -470,25 +469,25 @@
Application.ScreenUpdating = False
Application.EnableEvents = False
- ' Für Paare 2->18, 3->19...17->33 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
+ ' Für Paare 2->18, 3->19...17->33
For dataIndex = 2 To 17
-
+
chartIndex = dataIndex + 16
-
+
Set datenWs = ThisWorkbook.Worksheets(dataIndex)
Set diagrammWs = ThisWorkbook.Worksheets(chartIndex)
Set chartObj = diagrammWs.ChartObjects(1)
Set diagramm = chartObj.Chart
-
+
letzteZeile = datenWs.Cells(datenWs.Rows.Count, 1).End(xlUp).Row
letzteSpalte = datenWs.Cells(2, datenWs.Columns.Count).End(xlToLeft).Column
-
+
Set xRange = datenWs.Range(datenWs.Cells(3, 1), datenWs.Cells(letzteZeile, 1))
-
+
Do While diagramm.SeriesCollection.Count > 0
diagramm.SeriesCollection(1).Delete
Loop
-
+
For i = 2 To letzteSpalte
Set yRange = datenWs.Range(datenWs.Cells(3, i), datenWs.Cells(letzteZeile, i))
With diagramm.SeriesCollection.NewSeries
@@ -497,21 +496,33 @@
.Values = yRange
.Smooth = False
.ChartType = xlXYScatterLines
-
+
' --- Nur Linie, keine Punkte ---
.MarkerStyle = xlMarkerStyleNone
End With
Next i
-
+
' ---- Farben der ersten 3 Serien fest zuweisen ----
If diagramm.SeriesCollection.Count >= 1 Then diagramm.SeriesCollection(1).Format.Line.ForeColor.RGB = RGB(255, 128, 64)
If diagramm.SeriesCollection.Count >= 2 Then diagramm.SeriesCollection(2).Format.Line.ForeColor.RGB = RGB(255, 0, 0)
If diagramm.SeriesCollection.Count >= 3 Then diagramm.SeriesCollection(3).Format.Line.ForeColor.RGB = RGB(0, 128, 189)
+ ' ---- Legende nur ausblenden, wenn:
+ ' Datensatz 1 leer, Datensatz 2 leer, Datensatz 3 hat Werte ----
+ Dim hat1 As Boolean, hat2 As Boolean, hat3 As Boolean
+
+ hat1 = WorksheetFunction.CountA(datenWs.Range(datenWs.Cells(3, 2), datenWs.Cells(letzteZeile, 2))) > 0 ' Spalte B
+ hat2 = WorksheetFunction.CountA(datenWs.Range(datenWs.Cells(3, 3), datenWs.Cells(letzteZeile, 3))) > 0 ' Spalte C
+ hat3 = WorksheetFunction.CountA(datenWs.Range(datenWs.Cells(3, 4), datenWs.Cells(letzteZeile, 4))) > 0 ' Spalte D
+
+ If (Not hat1) And (Not hat2) And hat3 Then
+ diagramm.HasLegend = False
+ Else
+ diagramm.HasLegend = True
+ End If
+
Next dataIndex
Application.EnableEvents = True
Application.ScreenUpdating = True
-
-End Sub
-
+End Sub
\ No newline at end of file