Share via

Excel graph maximun/minimum values fetched from a cell

Anonymous
2014-05-28T12:35:33+00:00

Hi,

Can somebody help me?

I need to index/link the maximum and minimum values of a graph axis (vertical) from existing values in cells. So that they update automatically according to the values of the cells as they change.

It is possible to do this? How to do it?

Thank you allin advance

Roger(io) Fernandes

Microsoft 365 and Office | Excel | For home | 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

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2014-05-28T17:34:45+00:00

    Had a look on whatever google search showed up. It is definitely not possible without VBA as min and max options in Axis Options can't take cell reference. Hence, VBA is the only recourse.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2014-05-28T16:34:24+00:00

    Hi Andy,

    Although not exactly what I needed, because it uses VBA, my thanks for the solution presented.

    Thank you

    If anyone knows of another solution and without recourse to VBA, you're welcome

    Was this answer helpful?

    0 comments