Forum Discussion
Rob83
9 years agoFrequent Visitor
Min/Max column Chart
Hi all, I'm wondering if it’s possible to make a min/max column chart? I have an order lead time for every production order. To make it visible I have made a max order lead time were it show eve...
- 9 years ago
Hi Rob83
You can use the stock chart as you said and get thisCreate a new column MIN equal to MIN order lead time, do the same for MAX.
These will serve as the open and close values since the stock chart displays nothing if not all of its fileds are filled.
So eventually the open and low numbers, the max and high numbers overlap so the grey bar is hidden under the green bar.
And make sure the order lead time is formatted as a date.
From the formatting tab of the visual, you can turn off the trend lines so the yellow line doesn't show.
Tell me how it works!
Elisa_E
8 years agoHelper I
This is a great option to show min/max, but are dates requires always on the x-axis? Could you use another type of text variable?