Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Office

Reply
 
LinkBack Thread Tools Display Modes
  #1  
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
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
How can I make a table or chart to interpolate between values? lbeck Excel 7 10-03-2016 12:37 AM
Format Chart X axis - inconsistent values TimTDP Excel 2 12-01-2015 02:56 AM
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 11:48 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft