Tornado Demo - Working with a Live Excel<br>Display the Entire Range

Tornado Demo - Working with a Live Excel
Display the Entire Range

Owner_Type

Score

Graph

Wagon Owners

0.548

Utility Owners

0.4922

Innovators

0.4724

Sports Car Owners

0.4667

Getting Started

0.4111

Family w/Young Kids

0.408

Generation X (33 & younger)

0.4078

Truck Owners

0.3758

Pet owners

0.3674

Has children

0.3659

Works full-time or part-time

0.3624

Baby Boomers (34-52)

0.3602

Tow

0.3554

Does Not Consider This Brands

0.353

Use vehicle on the job

0.3526

Males

0.3515

Single

0.3465

Family w/Older Kids

0.3464

Van Owners

0.346

Considers This Brands

0.3452

Total Sample

0.3426

Married OR Living w/significant other

0.3424

Used Vehicle Buyers

0.34

Young Never Purchased

0.3279

Females

0.3261

Compact/Midsize Car Owners

0.3247

Car Owners

0.3138

Does not have children

0.3089

Pickup Owners

0.2978

Older Single/Couple

0.2881

Economy/Small Car Owners

0.2865

Luxury Car Owners

0.2729

Large Car Owners

0.2726

Pre-Boomers (53 & older)

0.2512

Not employed outside the home

0.2459

Retired

0.2227

Retired (45 & Older)

0.1929

ColGraph - Excel

<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
  Dim SS As New Tornado.Z()
  With SS
    .dbUnit=92
    .dbSkin="gold"
    .dbMode = "grid"
    .dbPageSize=-1
    .dbType="Excel"
    .dbDSN= "SSDemo.xls" 
    .dbSQL = "Select Owner_Type,Score,Score as Graph From [Range1]"
    .dbColGraph = "(,;)fi=Graph|icon=rainbow|wi=300|he=8|style=8|minmaxsql=SELECT min(Score), Max(Score) From Range1"
    .dbNavigationItem="none"
    .dbTextHolder="Title=Tornado Demo - Working with a Live Excel<br>Display the Entire Range"
    .ASPdbNET()
  End With
End Sub
</script>

This Column Graph plots the values directly from an Excel SS range [Range1]. You can set up as many plot ranges in the SS and each range can be a data source. The trick is to create a calculated field the same as 'Score' and instead of showing the numeric value, we show the graph. The plot scale is determined by the SQL retrieving the Min. and Max. of the field.