Support Board

Date/Time: Tue, 26 Nov 2024 06:41:50 +0000

Post From: Re: DRAWING RECTANGLE BY SPREADSHEET?

[2014-03-25 22:00:20] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4120
1) In the Zones Output spreadsheet settings, set the Draw Styles to Trans Fill Top/Bottom, and/or change the color. 2) Put =KF3 in the row 3 cell of a spare Formula Column, then set that column's Draw Style to Line. There are no spare Formula Columns in the Zones Output spreadsheet, so you'll need to change the Number of Formula Columns in the spreadsheet settings to something higher than the default 16. 3) Use two spare Formula Columns to calculate the %change, one for the zig and one for the zag, then set the Draw Style of each column's Draw Style to Value On High or Value On Low. If there are no spare Formula Columns, and you change the Number Of Formula Columns setting, the existing formula column references will not move to the new columns so those formulas will have to be edited. These are simplistic instructions. There are some caveats to overcome to make this work, especially #3.