excel charts

[aashishn86]

is there a way by which i can generate a excel report in asp and create a chart corresponding to it using asp as well...

[aashishn86]

that is i want to generate a chart dynamically when i export the data to an excel sheet using asp, in the same sheet .

[aashishn86]

well maybe i can do that using macros...
is there a way i can include macros in the excel page i make
i don't have excel installed on my server...

[jhardman]

The only way I have ever made excell files in requires that excell be installed on the server, but it should be possible since many other programs can export excell files. Still, the best example I know of is here and this uses a db connection and I don't think it will work to generate a graph.

Depending on your needs, you might be able to have a graph in place on a template page, and your script could just open it, change the numbers that feed the graph, and save it for the user. I could probably talk you through that if it would work for you.

Jared

[aashishn86]

hii ....... thanks..
i have already generated an excel file and imported it , the problem is making a graph.

"graph in place on a template page, and your script could just open it, change the numbers that feed the graph"

does that mean...generati ng a graph using html by retreiving the data from the database or something else ?

[jhardman]

does that mean...generati ng a graph using html by retreiving the data from the database or something else ?

No, I mean make a graph in an excel file using excel, having the values for the graph refer to a certain range of cells on the excel workbook. Then your script could open the file, change the numbers and labels that the graph uses and save it under a different name - then you would have a graph specific for the job run. Does that make sense?

Jared

[aashishn86]

that sounds good........
could you please explain , how i can do that.......
thank's...

[aashishn86]

i am waiting for your reply........
thank's...

[jhardman]

me too. I hope it's a good one.

As I was thinking about this, I realized I had already answered this a year and a half ago. try this and let me know if it helps.

Jared

BTW, in English we use the apostrophe-s ('s) ending in two cases:

1. when making a contraction of two words ("he's" is a shortened form of "he is" or "he has")
2. when showing possession by a noun ("John's" refers to something owned by John)

I can't imagine any case where "thank's" is correct. "Thanks" is actually a plural noun, as in "I give thanks to you", so an apostrophe is not appropriate. Please understand that I am telling you this in the hope that it helps you improve your English skills. I also admit that many English speakers do not understand this.

Jared

[aashishn86]

thanks
that helped but the
post didn't........
i want to generate a graph which dynamically gets the data from the database
and makes a graph in the excel sheet.......... ..