How to create a dynamic reference line in a bar chart

[cliff_clayman]

I have a bar chart with a specific reference line.  The reference line represents a target or a goal of 10%.  However, when the bar chart values go below 10%, I lose the reference line.  How can I make the reference line be dynamic and still display when the values dip below the reference line value?

[cliff_clayman]

No ones knows how to answer this question?

[vishsaggi]

Can you share a sample to look into? What is the expr you are using for your reference line. May be use Axis tab for static min and static max to enter min and max values. Not sure unless i see some information.

[vkish16161]

Cliff,

Can you please share a screenshot of the reference line expression you're using?

[cliff_clayman]

[vishsaggi]

Can you share a sample file?

[cliff_clayman]

No, the file is quite large and has proprietary information in it.

[Anonymous]

You'll need to set the max axis value on the Axes tab.

I don't know your dimension or expression but it would be something like this.

=rangemax(0.10,max(aggr(ChartExpression,ChartDimension))+0.05)

[vishsaggi]

What is your expression you are using for your bar chart? As Atkinson mentioned you have to write an expr in Axes tab.

[cliff_clayman]

My chart doesn't have a dimension and it has 13 different expressions.