View Single Post
 
Old 11-25-2017, 10:58 AM
MitzDriver MitzDriver is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2015
Location: Weyers Cave, Va
Posts: 1
MitzDriver is on a distinguished road
Default VBA code to set xaxis chart values

Tired myself but not that good a vba.

Would like VBA code to set the minimum and maximum value of the chart 4 xaxis with the min & max value in a range named dbyear.

i.e.
Chart 4 Xaxis minimum value = the minimum value of a range named dbyear.
Chart 4 Xaxis maximum value = the maximum value of range named dbyear.

Sounds simple but just can't get it to work.

Thanks in advance. Any help would be greatly helpful.
Reply With Quote