We're presently running Microsoft Windows 2000 Advanced Server and using IIS to host a website which contains ASP and HTML pages. Right now some of these pages refer to databases (Access/SQL) on the server to deliver dynamic content to the user, but not on the scale we'd like. I'm wondering which technology or technologies should be pursued to achieve a more dynamic, robust, live web application.
Some of the features we'd like to provide include both static and drag-and-drop-interactive spreadsheets (a-la Excel pivot tables), dynamic forms, and charts and graphs. We're looking for a clean and simple interface which doesn't require much of the user. My present server-side coding experience is with VBScript/ASP.
I know this is a broad question. I'm open to all suggestions.