This topic is locked

Chart Help

1/26/2009 3:48:39 PM
ASPRunnerPro General questions
C
cloudy author

Hi,

Can anyone here help me with a chart in ASP Pro 6, I have a data set from an SQL query that returns data as follows:

Area Qty

NameOfCell1 10

NameOfCell2 20

NameOfCell3 10

NameOfCell4 5

And so forth.................

When I chart the Qty on the Y axis against the Area on The X axis using a Bar Chart,

the chart X axis labels do not show for each data point plotted,

i.e I want NameOfCell1, NameOfCell2, NameOfCell3, NameOfCell4 on the X axis with the data points 10, 20 ,10,5 corresponding to them.

What I actually get is:

NameOfCell1, NameOfCell3 with the data points 10,20 and 10,5 i.e two data points grouped together with the label albeit they have separate bars on the chart but no individual labels on the X axis to indicate what they are, if you hover the mouse pointer over them you can tell, but this is not really much good if the chart is printed out.

Anyone seen this before? Or could point me in the right direction to fix the problem? There does not seem to be any configuration in ASP Runner, so I guess I need to change the Code generated that configures AnyChart.

Many Thanks,

Ian

D
dlangham 1/26/2009

Have you ticked the "Show values" option on the Chart appearance page?

C
cloudy author 1/31/2009

Hi Dale,

Thanks for the reply, yes I have checked the show values box but it still only labels every other data point on the x axis. It plots that data fine, but I just need it to display the x axis labels for each data point not every two. as its miss leading.

Cheers,

Ian

J
Jane 2/3/2009

Ian,
It's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.

C
cloudy author 2/4/2009

Hi Jane,

Its Difficult to upload the database for me as its on our Local SQL server, and company data protection rules mean that I would have to make something up and therefore it would not be representative of the current situation.

However I have managed to fix the problem I was having, the charting component used are AnyChart v5 and these are much more configurable than the visual editor in ASP Runner would lead you to believe. By manually editing the XML file script that creates the settings for each chart you can do much more with the charts. The script file that generates this is called "dchartdata.asp"

Not sure if its a bug or I am miss interpreting the visual editor in ASPRunner but if I want a chart to show more than 20 records I change the Records on Page setting on the miscellaneous tab. However the chart still only displays the first 20 records. This can be changed by manually editing the dchartdata.asp file. Also to get the X axis labels to read per bar or data point, I just add the setting "Rotation = ""90" into the XML code in dchartdata.asp therefore giving the chart a chance to fit the labels in.

Might be worth adding some more functionality to the visual editor in the charts section to allow less able users to make changes like this for the next release - I don't think it would that much work to do.

Although these are minor things in the grand scheme of things I think little bits like this can make a good product like ASP runner into a great one. I look forward to the next release.

Thanks for your help,

Ian