Share via

Chart setting / Axis Options / Bound / Y Axis - couldn't set the cell reference for Minimum/maximum value

Anonymous
2024-03-23T19:28:29+00:00

What I am trying to achieve:
Dynamic Minimum value for the Y axis based on the cell (A1), where I have calculated the value using formula.

What's happening:
Once I have entered the value and hit enter or tab, this field is automatically going to back 0.0.

What I have Done so far?

  1. I hope the syntax is =$A$1. But I have tried other combinations as well, as given below.
    =A1

'=A1'

"=A1"

=$A$1

'=$A$1'

"=$A$1"

  1. Use System Operators - Tested by enabling and disabling this check box in File/options/advanced
  2. Recreated the chart from scratch
  3. Tried with new excel file.

Any help would be much appreciated.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest