Making a graph with easily changed dates

  • Thread starter Thread starter Sean123
  • Start date Start date
S

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!
 
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
 
Back
Top