Microsoft Office Forums VBA code to set xaxis chart values

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-25-2017, 10:58 AM
MitzDriver MitzDriver is offline VBA code to set xaxis chart values Windows 10 VBA code to set xaxis chart values Office 2016
Novice
VBA code to set xaxis chart values
 
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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error bars in bar chart only show positive values dutchLing Excel 1 07-07-2017 11:37 PM
VBA code to set xaxis chart values How can I make a table or chart to interpolate between values? lbeck Excel 7 10-03-2016 12:37 AM
VBA code to set xaxis chart values Format Chart X axis - inconsistent values TimTDP Excel 2 12-01-2015 02:56 AM
VBA code to set xaxis chart values Generate chart from list of text values knownunknown Excel 6 04-24-2013 01:56 AM
Word chart with words for y-values? Computerbum Office 0 09-19-2011 07:09 PM


All times are GMT -7. The time now is 07:12 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft