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!
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.
adam fehr commented
This feature is something I would've expected to be part of the latest version..., Still waiting
Jason Peters commented
I dropped in to make this exact same recommendation. I routinely overlay charts and can never be guaranteed to get the max and min (X or Y axis) values to match up when setting the scales to 'auto' - plus I generally scroll varying data through my charts so I cannot really use fixed MAX and MIN values either. The best thing I have come up with is to use a scale factor to force all values between say 0 and 1, but this then results in a loss of knowledge of the actual values, dates, etc if you want to hover over the chart to get the value at some point. If there was a way to simply link the chart boundaries to cells then users could simply force any overlaid charts to scale appropriately with their changing data. Users would also have the luxury of very easily being able to scale their chart images without needing to multiply every single X and/or Y value by a scale factor to ensure it fits within the chart bounds and is sized correctly in x and y. I know I'd get a lot of use from this feature and hopefully the community feels the same.
This was identified as a requirement in November 24, 2015. It's key to productivity. VB is not the answer. IS THERE ANYBODY THERE, MICROSOFT?
Bruce Dehm commented
Our firm creates over 70 charts per client per month and we have more than 60 clients. We have had to create macros to adjust axes and honestly VBA doesn't always play nice with other software needed to generate reports. There are so many obscure functions in Excel, so why not fix something that is so useful to everyday users? Please move this needed function to the front of your to-do list.