UDF Function to manipulate charts - great article needs tweaking for my purpose

[mountainman88]

I found this great article for creating a UDF to manipulate charts and it works great.

How to set chart axis based on a cell value

The chart axis min and max settings are fixed values. This posts looks at a automated method to set chart axis based on a cell value.

exceloffthegrid.com

How can I modify this to create a UDF where I can link 1) chart title where the UDF argument is a cell 2) The data range for the chart,where the UDF argument is a range of cells (this would be the same as the data source range when setting up the chart)

Thanks!

 

[BSALV]

a known problem ?

https://answers.microsoft.com/en-us/msoffice/forum/all/formatting-of-data-labels-for-waterfall-charts-in/79c002c0-09ab-4bd0-9275-fe8725d781c0

 

[BSALV]

your link gives the best description and yes, waterfall isn't supported, so nothing to do about it.

 

[mountainman88]

a known problem ?

https://answers.microsoft.com/en-us/msoffice/forum/all/formatting-of-data-labels-for-waterfall-charts-in/79c002c0-09ab-4bd0-9275-fe8725d781c0

This is based on a waterfall created in PowerPoint 2012. Could be related but might not be.

 

[Jon Peltier]

Just to confirm, the new chart types introduced in 2016 and later are not as fully functional as the other charts. Some things cannot be adjusted in the user interface (like the Y-axis major unit in the waterfall), and some things that can be adjusted in the user interface cannot be changed in VBA.