Dan Kennedy
New Member
I have a spreadsheet that I am pulling data off a server and creating different graphs. I am trying to expand the functionality of the spreadsheet so that if the 1 day & 1 minute option is chosen all the graphs have a minute scale X axis. However when I go to monthly and annual time frames I need the X axis to switch to a date format. I have created named ranges for the minute scale and the day scale but I cannot figure out how to get excel to automatically change this axis format. Anybody have any ideas, I am not stellar with VBA but I am willing to try it.
Thank you,
Dan
Thank you,
Dan