Support Board

Date/Time: Tue, 21 May 2024 12:34:24 +0000

Post From: Overlaying Pivot Points

[2021-08-14 00:36:27] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4002
When draw style is Dash, pivots cover the whole width of corresponding bars, I changed draw style of PP to Line, you can see the difference in the attached files. The Dash draw style draws a dash from the left edge to the right edge of the bar's width. The Line draw style draws a line from the center of the bar's width to the center of the adjacent bar's width center. Because of the, Dash is the preferred draw style for pivots. Looks like I don't need the K3 formula, since I do this: AND(INTDATE(Sheet2!$A$3)=TODAY()=INTDATE(A3)) Am I wrong? That should work. Why the chart won't update automatically to match the current spreadsheet values? Probably a calculation precedence issue. Make sure the studies are in calc order in the Studies to Graph list. You could add the Chart Recalculation - Periodic study.