January 10, 20233 yr In FM charting, is there a way to prevent the longest bar (or stacked bars) from taking up the entire width? In the image below you'll see a chart based on 'time' data spanning only a few minutes. I'd like the full width of the chart to represent 1 hour (for example) therefore the lines would only fill 10% of the chart width currently. I know there are multiple other options such as JS, buttonbars, repeating fields, etc., but traditional charting is doing what I need with this exception. Thanks.
January 10, 20233 yr 13 minutes ago, Jeffrey Bloch said: I'd like the full width of the chart to represent 1 hour (for example) In Chart Setup > Chart > X-Axis select the Set Maximum option and enter a value that represents 1 hour.
January 10, 20233 yr Author 3 minutes ago, comment said: In Chart Setup > Chart > X-Axis select the Set Maximum option and enter a value that represents 1 hour. I played with that and it seems to only limit the data (ie won't display time segments 'less than' or 'greater than' entered values. Is this wrong? I found one method of achieving the desired result without creating a new dataset for the only purpose of tricking the chart into a new MAX value. The method is less-than-optimal, so I'm still hoping for a better method. The concept pictured here utilizes multiple buttons covering sections of the bar area of the chart, then using Conditional formatting to color sections white (or vice-versa) depending on the data values I'm working with.
January 10, 20233 yr 10 minutes ago, Jeffrey Bloch said: I played with that and it seems to only limit the data (ie won't display time segments 'less than' or 'greater than' entered values. Is this wrong? I believe it is. See if the attached demo does what you asked for. chartMax.fmp12
January 10, 20233 yr Author 32 minutes ago, comment said: I believe it is. See if the attached demo does what you asked for. I believe you're right. Thanks!!
Create an account or sign in to comment