Making a graph with easily changed dates

[Sean123]

My boss asked me to make a graph on one of his spreadsheets more user
friendly...so that you could put a start and end date in two ajacent cells
and the graph will automatically change to show the time between those dates.
I didn't think it was going to be too hard but now i'm completely
stumped...I've got the dates on the X-axis and 3 other lines that come from
data on another sheet...and i can't even get the X-axis to easily adjust to
two changeable dates (it will just show those two days rather than all the
days inbetween).....if anyone has any suggestions i'd greatly appreciate it.
thanks!

 

[Sean123]

smartin,
Thanks for the reply...those links were really helpful! I think i've almost
got it figured out with one last hangup....I've got it so it will plot all
the appropriate data inbetween the dates, but I can't get the actual scale of
the x-axis to change as i change the start/finish data.... I've been checking
out those sources and haven't found anything, if you think you know a way
that'd be awesome....otherwise, for now i could just put a note below the
input dates instructing to change the scale of the x-axis accordingly

Thanks, hope you have a great weekend!

Sean

 

[Jon Peltier]

I think this link would have been the best place to start:

Dynamic Charting By Dates
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=246

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______