Hi,
I am struggling since 2 days with the following issue, I have a sheet where are collected data for the analysis of the performance of an Heat Exhanger .
It is necessary to visually analyze the data collected and then highlight some points in this graph.
For the first step I have used same macros that change the Maximum and Minimum of the date scale ( macros "ScaleAxes_Plus" and "ScaleAxes_Minus" ) that are activated by the arrows Year+ and Year- that are on the top left corner of the graph ..and till now no problem.
Then for the second step of highlighting some points in the graph I have used the method indicated in this link -> Highlighting Data Points in Excel Scatter and Line Charts | Chandoo.org - Learn Microsoft Excel Online .
But there is something that doesn't work in coupling the first step with the second one because the highlighting method works till I use the slider with the first year ( 2012 ) data ...when I move ahead to the 2013 data .. then even if the min and the max of the slider are updated correctly using the following macro :
Sub ScrollBarChange_Min_Max()
ActiveSheet.Shapes.Range(Array("Scroll Bar 15")).Select
With Selection
.Value = Range("RngStart").Value
.Min = Range("RngStart").Value
.Max = Range("RngEnd").Value
'.SmallChange = 1
'.LargeChange = 10
.LinkedCell = "$Z$23"
'.Display3DShading = True
End With
End Sub
nothing happens .
I have even entered manually some data in column BE that is the one that is used to simulate the selection of one point in the graph ( I have entered several values equal to 10 from the BE402 ahead ) ..and they are displayed in the graph named test but not in the graph in which is dinamicaly changed the date range .
I have uploaded a sample file in Dropbox that shows what above described and attached is the link for downloading https://www.dropbox.com/s/r97gbv8f741aozp/Predix_Template_StrippedDown.xlsm?dl=0
..Now my brain is completely melt
Thanks in advance for any help and suggestions
Best regards
Franco
I am struggling since 2 days with the following issue, I have a sheet where are collected data for the analysis of the performance of an Heat Exhanger .
It is necessary to visually analyze the data collected and then highlight some points in this graph.
For the first step I have used same macros that change the Maximum and Minimum of the date scale ( macros "ScaleAxes_Plus" and "ScaleAxes_Minus" ) that are activated by the arrows Year+ and Year- that are on the top left corner of the graph ..and till now no problem.
Then for the second step of highlighting some points in the graph I have used the method indicated in this link -> Highlighting Data Points in Excel Scatter and Line Charts | Chandoo.org - Learn Microsoft Excel Online .
But there is something that doesn't work in coupling the first step with the second one because the highlighting method works till I use the slider with the first year ( 2012 ) data ...when I move ahead to the 2013 data .. then even if the min and the max of the slider are updated correctly using the following macro :
Sub ScrollBarChange_Min_Max()
ActiveSheet.Shapes.Range(Array("Scroll Bar 15")).Select
With Selection
.Value = Range("RngStart").Value
.Min = Range("RngStart").Value
.Max = Range("RngEnd").Value
'.SmallChange = 1
'.LargeChange = 10
.LinkedCell = "$Z$23"
'.Display3DShading = True
End With
End Sub
nothing happens .
I have even entered manually some data in column BE that is the one that is used to simulate the selection of one point in the graph ( I have entered several values equal to 10 from the BE402 ahead ) ..and they are displayed in the graph named test but not in the graph in which is dinamicaly changed the date range .
I have uploaded a sample file in Dropbox that shows what above described and attached is the link for downloading https://www.dropbox.com/s/r97gbv8f741aozp/Predix_Template_StrippedDown.xlsm?dl=0
..Now my brain is completely melt
Thanks in advance for any help and suggestions
Best regards
Franco