Jump to content
Software FX Community

X-axis values


User (Legacy)
 Share

Recommended Posts

Hi

I have a dataset containing the values

1, 700

2, 200

9, 5

The 1, 2 and 9 represents months. I would like to define my x-axis with the

values from 1 to 12 and then submit my dataset to the control. The

result-grid should still have the values from 1 to 12 but ofcourse only show

the data from the dataset (the other months would just have 0 as value)

I have searched in the documentation, but have not found it.

How do I do this?

Thanks!

Best regards

Soren, Denmark

Link to comment
Share on other sites

You can do this with an X/Y chart (Lines Scatter, Area, etc.) You can not do

it with a bar chart as bar charts use "discrete" data in the X-Axis, in

other words the X-Axis in a bar chart is "categorical" meaning that it is

just a collection of bars one drawn after another, the position of each bar

is determine by its order in this collection.

What you can do to achieve your chart is the following:

You need use OpenData-CloseData to set up a chart with 12 points. Use

COD_ALLOCHIDDEN to initialize these points as hidden values.

Then you need to go through your resultset and using the first column as an

index, you will set the value of each bar:

foreach record

index = <value of field one>

value = <value of field two>

chart.ValueEx(0,index) = value

end

Notice that this approach requires that there is only one value per month,

if there is two, the last one will prevail.

--

FP

Software FX

Link to comment
Share on other sites

I am not sure I understand (I only have an OpenDataEx and there's no

COD_ALLOCHIDDEN) !?

I am doing the following:

Set chart = Server.CreateObject("ChartFX.WebServer")

Chart.RgbBk = RGB(255,255,255)

Chart.Gallery = BAR

Chart.Chart3D = False

Chart.Stacked = CHART_NOSTACKED

Chart.Border = False

Chart.LegendBox = False

Chart.SerLegBox = False

Chart.ToolBar = False

Chart.TypeMask = 109576194

Chart.DataType(0) = CDT_LABEL

Chart.DataType(1) = CDT_VALUE

Chart.AdoResultSet rs

GetChart = chart.GetHtmlTag(351, 300, "ActiveX")

Could you please explain or show by an example how I should create the chart

instead to have the 12 points on my x-axis?

Thanks for swift answers.

Best regards

Soren, Denmark

"SoftwareFX Support" <noreply@softwarefx.com> wrote in message

news:VOsfQVeBEHA.200@webserver3.softwarefx.com...

> You can do this with an X/Y chart (Lines Scatter, Area, etc.) You can not

do

> it with a bar chart as bar charts use "discrete" data in the X-Axis, in

> other words the X-Axis in a bar chart is "categorical" meaning that it is

> just a collection of bars one drawn after another, the position of each

bar

> is determine by its order in this collection.

>

> What you can do to achieve your chart is the following:

>

>

> You need use OpenData-CloseData to set up a chart with 12 points. Use

> COD_ALLOCHIDDEN to initialize these points as hidden values.

>

> Then you need to go through your resultset and using the first column as

an

> index, you will set the value of each bar:

>

> foreach record

> index = <value of field one>

> value = <value of field two>

>

> chart.ValueEx(0,index) = value

> end

>

> Notice that this approach requires that there is only one value per month,

> if there is two, the last one will prevail.

>

> --

> FP

> Software FX

>

>

Link to comment
Share on other sites

Instead of:

Chart.AdoResultSet rs

You need to do:

Chart.OpenDataEx COD_VALUES, 1, 12

For i = 0 To 11

Chart.ValueEx (0,i) = CHART_HIDDEN

Next

Chart.CloseData COD_VALUES

This will initialize your chart with 12 "empty" points.

Then you need to go through your resultset and do:

foreach record

index = <value of field one>

value = <value of field two>

Chart.ValueEx(0,index) = value

end

--

FP

Software FX

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...