How to set automatic axis
Hi guys,
I have a horizontal bar chart named Project Date. This chart has Automatic y-axis with task names. How do I make it so the dates on the x-axis is also automatic? I want the auto date to range from A32- A123.
Or I want to be able to select the bounds on y-axis as tasks and auto select bounds based on data for x-axis(dates)
Thank you in advance!!
Excel does not have a built in way to link chart axis limits to cell values, so you would need to use VBA to write your own procedure that will do this. Two approaches that I see being used:
https://peltiertech.com/link-excel-c...lues-in-cells/
https://peltiertech.com/chart-udf-control-axis-scale/
Choose the technique you like and adapt Peltier's code to your specific scenario. If/when you get stuck, let us know how we can help.
Originally Posted by shg
Hi MrShorty,
I tried the VBA but its just way too much for me... I'll just change the min and max bounds every week, it won't be a big deal.
Thanks again!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks