Link the min and max values of a chart axis to cell value
It would be nice to be able to link the min and/or max value of an chart axis to a cell reference instead of manual enter the value or the auto function.
Thank you for taking the time to share your request for linking min/max values of a chart axis to the cell value! We think this suggestion has merit; however, we don’t expect to devote time to it in the near future. We will continue tracking votes and comments here, and will keep this suggestion under consideration for future development.
Thank you again, and please keep sharing your thoughts!
This is why peolle are running away from Excel for newer, better, less buggy, more user friendly programs for analysis
Lucas Ferronato commented
this should be in roadmap! Nothing is easy, but i don't believe that is really hard to be implemented
Thanks for tracking the comments, but this is a real-world problem that we have been trying to get addressed since 2015!!
This would be really helpful- I'm confused it's not implemented
Bernd Rademacher commented
Excel is using strange bounds in an xy scatter plot and goes even beyond the range of values. It is not practical to adjust the bounds manually as the data are changing from case to case. In other words: I need an option where I can set the bounds according to a cell value and/or a logical name. Please implement this as soon as possible. Many thanks in advance.
B Dehm commented
You are correct. Chart titles and axis labels can be referred to by a cell address.
This request to allow one to enter a cell address for the Minimum and Maximum Bounds on a chart's Axis. Currently, one can select "Automatic" or manually enter a number in the Format Axis window. (VBA options are also possible). One is not allowed to enter a cell address into the Minimum or Maximum field in the Format Axis option.
@Francisco - If you are meaning that you want to change the chart title, axis label, or even the data labels by simply changing a cell value, then you can already do that by replacing the label text with a cell reference ie. instead of "Total Sales", use "=A1". One caveat, you can not use a formula like =A1&" Totals". It needs to be a single cell reference. But A1 could be any formula you want. Then just reference A1 in your chart.
I use this technique for dynamic charts where both the data ranges and the labels can be changed by simply selecting a the desired options from a few cells that have predefined data validation values.
Ideally not only Min and Max, any value setting should have the option to be taken from a cell value.
Perhaps join me in tweeting about it to @MSExcel and @Microsoft
B Dehm commented
The last time MSFT responded to these multiple requests at almost five years ago. I do believe that nobody is listening to our request to link min/max values to a cell reference.
Arne Munther commented
Sound like a VERY good idea.
Fred Prinz commented
Adding the ability to link chart bounds to a cell reference would be very useful. Should have been added years ago.
Philip Leicester commented
I so often find myself thinking, Excel team, you have a fab spreadsheet tool which can actually deliver amazing powerful declarative applications.
As an adjunct to this you have crappest data visuallsation tool which you can still see elements from Office 95 and earlier. Sizing any element of a chart (not just max, min) needs to be in the user hands, and not from your (rather useless) GUI.
We work your tool hard, but you make us work too hard to report our efforts to those who need to see them!
Hello, the isolated dates in charts is really inexplicable ! Please add the link functionality.
Daniel Goodland commented
I made this suggestion 5 years ago! It is in the TOP 5 in votes!! Make it a reality already!!!
How bout at the beginning of creating a series. null values default to the auto option:
=SERIES(<Label>,<X-axis>, <Y-axis>,<index>,<X-axis Label>,<X-axis lower bound>,<X-axis upper bound>,<Y-axis Label>,<Y-axis lower bound>,<Y-axis upper bound>)
Lets do this bois and gals!
This could easily save me days of menial work a year to make graphs look good for presentations.
VB does not work when using Jet Reports. Sounds simple, allow the Min and Max Bounds to be set by a cell reference. Long overdue
Ron Wallace commented
Glad to see so many votes - this is long overdue. Just count the steps necessary to change these values when not using auto-scaling. Auto-scaling is great but not when you are comparing items in several charts and the axes should be the same.