Chart with Editable Date Range (user specified start date)

**starryknight64** · 06-11-2009, 12:13 PM

Not entirely true. You can do various things to keep the user from seeing data you don't want to be seen (like protecting sheets for instance--which I don't know how to do).

You can also straight up hide the cells you don't want to be seen. Just select the rows or columns you want to disappear, right click, and select hide.

I hope this helps!

**fateshand** · 06-11-2009, 12:35 PM

Thanks Bud! It does help on one of the questions. However, if anyone else can address the GUI type of interface or input cell that could possibly update the starting date on the chart without the user having to get into any code or anything like that, I'd appreciate it.

**starryknight64** · 06-11-2009, 12:59 PM

Would it be alright to have the user open up a spreadsheet (perhaps--this very one we're working on) and have a form pop up after it opens?

**fateshand** · 06-11-2009, 01:50 PM

Yeah, a form would be great. I think I could really put that to use.

**ChemistB** · 06-11-2009, 01:53 PM

I would think this could be solved with Named Ranges to define your dynamic range but I'm having a mental block as to how to do it specifically. :-/

**Andy Pope** · 06-12-2009, 05:03 AM

I would go with a lookup. Your chart is based on a fixed range of cells. That range of cells is populated using INDEX function.

Check this previous thread
http://www.excelforum.com/excel-char...l-clicked.html