Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Graphs in VML
Has anyone got a simple example of how I can dynamically produce a bar chart on a web page based on a differing recordset - using VML
I need a simple example where I can specify the limits of the X and Y axis and the differing height of 3 bars.
I believe VML is the best way to do this. If not what other options are there without any client side requirements.
Thanks
I need a simple example where I can specify the limits of the X and Y axis and the differing height of 3 bars.
I believe VML is the best way to do this. If not what other options are there without any client side requirements.
Thanks
Asked:
-
3
1 Solution
And here is an example of a vertical bar chart :
...
<table cellpadding=5>
<tr>
<%
ylimit = 100
tableheight = 300
do while not rs.EOF
%>
<td valign=bottom>
<table height=<%=(rs("value")/yli
</td>
<%
loop
%>
</tr><tr>
<%
rs.movefirst
do while not rs.eof
%>
<td><%=rs("name")%></td>
<%
loop
%>
</tr></table>
...
if you take advantage of the various table parameters (ie cellpadding, etc) you have considerable formatting options. To change the width of the bars, increase or decrease the number of " "'s in each one. To change the spacing between them, modify the cellpadding parameter, etc etc.
...
<table cellpadding=5>
<tr>
<%
ylimit = 100
tableheight = 300
do while not rs.EOF
%>
<td valign=bottom>
<table height=<%=(rs("value")/yli
</td>
<%
loop
%>
</tr><tr>
<%
rs.movefirst
do while not rs.eof
%>
<td><%=rs("name")%></td>
<%
loop
%>
</tr></table>
...
if you take advantage of the various table parameters (ie cellpadding, etc) you have considerable formatting options. To change the width of the bars, increase or decrease the number of " "'s in each one. To change the spacing between them, modify the cellpadding parameter, etc etc.
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
If your graphing needs are relatively simple, you could generate a simple HTML table to create your graph, in the form of a horizontal bar chart. This would guarantee client-side compatibility.
i.e. given a recordset rs with two fields, "name" and "value,"
...
<table width=100%>
<%
xlimit = 100
do while not rs.eof
%>
<tr><td align=right><%=rs("name")%
<table width=100% bgcolor=blue><tr><td width=<%=(rs("value")/xlim
</td><td></td></tr>
<%
loop
%>
</table>
...
You could add modifications to cycle the color as well.