Support Board
Date/Time: Fri, 28 Feb 2025 13:39:53 +0000
Post From: Overlaying Pivot Points
| [2021-08-14 16:16:04] |
| Botan626 - Posts: 294 |
|
I really don't understand, why you call this approach innovative. I just output data from source chart to sheet #2, then use that data on sheet #1 to calculate pivot formulas. I think it's as simple, as it can be. Although you can reference another sheet, it is not recommended to do so when using data from other charts.
Yes, but in the end Spreadsheet produces correct pivot values, it's the chart, that doesn't update automatically. I asked SC support about this in the new thread: Chart doesn't update with new spreadsheet values It is still not clear to me why you need to only display 1 day on your source chart.
Because I need to see pivots on the destination chart for 1 day only, so I consider plotting pivots for multiple days on the source chart as excessive. I found a way to solve this problem. Now I use only date data from sheet #2 and I get pivots data from overlay study on the destination chart. Pivots are plotted correctly for desired day on the destination chart with time-based or range bars without chart recalculating, using any Days-Mins-Secs Per Bar setting on the source chart. I attached the files, in case you or anybody else would like to see them. Thank you, Tom, for your help, explanations and inputs. Date Time Of Last Edit: 2021-08-15 11:52:00
|
 02.Cht - Attached On 2021-08-15 11:51:48 UTC - Size: 13.29 KB - 182 views Pivots.scss - Attached On 2021-08-15 11:51:54 UTC - Size: 44.1 KB - 255 views |