David's point, as usual, is right on.

I would ask why not invest the time getting a comparable graph out of SAS/Graph. I know it can be a chore at times to get SAS/Graph to produce nice graphics, but it can be done.

And if you use SAS/Graph, ODS will take care of titles, footnotes, rendeering the image - all to your user's browser.

Just another thought.

-don h

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of David L. Cassell Sent: Wednesday, February 16, 2005 4:19 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: viewing Excel output on internet--SAS inter/net

nevin <nevinkrishna@HOTMAIL.COM> replied: > I apologize for the confusion, i think i confused myself disregard the > entire part about the user altering titles etc.. > Basically what i am trying to get is an excel chart to be delivered > to a users browser.. > What i have is an html form which has two variables, year (in a drop > down box) and disease (in a drop down box) when a user selects a year > and a disease and clicks a submit button, a sas program is invoked > which populates a two columns in an excel file (saved on the > server),with the number of cases of a disease by month for the year > selected. This excel template on the server has the graph already > created, so everytime the user submits a different year and disease > request, the graph changes accordingly..This all works fine when i test > it, but i can not figure out how to have the user view the graph on > their browser.. > > i hope this is a bit clearer..

Yes, this is a bit clearer. Thanks. But I still don't see why you want to push an entire Excel spreadsheet down to a user's platform. All you need to do is set up a system to display a simple graph, which is very different.

In fact, you can simplify this even further, by creating all the graphs ahead of time, and then, given a particular year-disease pair, pull up the appropriate graph in real time. Do you really need more than this?

David -- David Cassell, CSC Cassell.David@epa.gov Senior computing specialist mathematical statistician