I am able to build a spreadsheet with a graph that changes the series for the Y-Axis by utilizing form control. That way with a click of the button in the chart I can change the data displayed in the chart.
Is it possible to do this for the X-Axis? To be able to quickly change the time frame? By using form control? I have tried building a text string that changes dynamically but I cannot seem to get the "Select Data" box to accept the text string.
Sorry if that is unclear.
Last edited by ejdrouil; 07-15-2013 at 04:12 PM.
currently reviewing the SOLVED posts below. Looks to be some type of solution...
Is this solved?
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Yes this is solved.
Actually I found a workable solution in the first similar thread listed below. Here is a link to the thread.
http://www.excelforum.com/excel-char...xis-chart.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks