Using charts in ASP pages

[rd]

Hiiii
In my project i want to use charts in ASP pages. Presently i am using MS
chart control but the look and feel of it is not so good.
Is it possible to use excel charts in ASP pages? ( I have used it extensively
in VB/VC applications.)
Are any third party tools available for displaying charts on ASp pages.

Pl note that charts are created dynamically. What i mean is that based on
certain form inputs data is fetched from DB and then chart is created with
that data.


Thanx

[Harish Kumar]

You can create Excel charts (with data retrieved from database) from ASP in
altogether 3 ways, viz.,

1. Calling EOM (Excel Object Model) directly
2. Using OWC (Office Web Components) and
3. Using a 3rd party tool. The one tool that comes to my mind immediately

is ExcelWriter from SoftArtisans (www.softartisans.com)

Programming using EOM (particularly in chart generation) is kinda tough one.
Regarding programming with OWC, some time back I saw a great article written
by ASP guru, Scott Mitchel in www.4guysfromrolla.com. But I think the easiest
way is using the ExcelWriter. When I saw last time, SoftArtisans were offering
a free version of ExcelWriter.

Harish Kumar
"rd" <phantom2k@rediffmail.com> wrote:
>
>Hiiii
>In my project i want to use charts in ASP pages. Presently i am using MS
>chart control but the look and feel of it is not so good.
>Is it possible to use excel charts in ASP pages? ( I have used it extensively
>in VB/VC applications.)
>Are any third party tools available for displaying charts on ASp pages.
>
>Pl note that charts are created dynamically. What i mean is that based on
>certain form inputs data is fetched from DB and then chart is created with
>that data.
>
>
>Thanx
>
>
>
>

[Bullschmidt]

I recently developed a free ASP bar chart tool with the following features
but you do have to loop through your recordset to fill an array with the
data:

o Built as a pure ASP class so there are no components to register and code
is still hidden behind the scenes.
o If one puts the cursor over a bar, its value is shown as a tooltip.
o Tooltip and y-axis values can be rounded and formatted to look like $1,234
instead of 1234.12.
o The Y-axis min and max can be set or calced from the data and the min can
even be negative.
o Chart data area size can be set.
o Text size and style can be set.
o The chart can be aligned on the page left, center, or right.
o If y-axis min and max are calced from data, they are set to round numbers
such as 950 instead of 947.
o Title and footers can be shown with multiple lines of text.
o Bar colors can be set otherwise default colors are used.
o The Legend can be shown or not shown.
o X-axis data or series labels can be shown or not (but these can make the
graph wider).
o The only required setting is the 2-dimensional data array itself.

Best regards,
-Paul

Bullschmidt.com - Web Database Developer
http://www.Bullschmidt.com
Bullschmidt Bar Chart - Free ASP Bar Chart Tool
http://www.Bullschmidt.com/BarChart.asp


"rd" <phantom2k@rediffmail.com> wrote:
>
>Hiiii
>In my project i want to use charts in ASP pages. Presently i am using MS
>chart control but the look and feel of it is not so good.
>Is it possible to use excel charts in ASP pages? ( I have used it extensively
>in VB/VC applications.)
>Are any third party tools available for displaying charts on ASp pages.
>
>Pl note that charts are created dynamically. What i mean is that based on
>certain form inputs data is fetched from DB and then chart is created with
>that data.
>
>
>Thanx
>
>
>
>