close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

shorten range

Thread began 11/11/2009 10:53 am by biz295654 | Last modified 3/29/2011 8:24 am by jcholt7640 | 2932 views | 6 replies |

biz295654

shorten range

I have graphs using dynamic web charts, using dynamic settings. However, I need to shorten the range of the data. All the readings are very close to one another, ie, 325.44, 366.17, etc. and I need to be able to display that difference. However, the graph starts at 0 even though my database starts at 317. So, how do I start the range at say, 300? Screen shot attached.

Thanks for assistance.

Sign in to reply to this post

Dani Chankhour

I'm not exactly sure if you can start your chart at a number beside 0. However, have you tried grouping your x label. Under the Data tab, under the X Label, there is a group by option which lets you group certain values. Usually that is used to group dates so i'm not sure if that could be applied in your chart.

Sign in to reply to this post

biz295654

yes, I tried that too... no joy. How about in the data1.php resulting query... maybe some = or < insert into the query?

Sign in to reply to this post

biz295654

Any thoughts on where to experiment? I'd think a > than 200 would be a solution, but where to put it...

Sign in to reply to this post

Dani Chankhour

Hi, I did some testing and it looks like Dynamic Web Charts gives you the ability to change the initial value. In your Dynamic Web Charts folder you should have two files specific to your chart:

yourpage_data1.php and yourpage_dateparser1.php

Open the yourpage_data1.php and look for your y-axis line:

<yaxis color="#767a7f" gridcolor="#888d93">

and change it to:

<yaxis color="#767a7f" gridcolor="#888d93" min="2">

Similarly you could make the same change for your x-axis.

Sign in to reply to this post

biz295654

Excellent! I also added a max="xx" and that really tightened it up. Perfect! Thanks for taking the time to find a solution.

In action: waterchart.php

Sign in to reply to this post

jcholt7640

Works great with recordset too

Thanks for posting this topic.

It gave me some good ideas and my charts look better tightened up as well. I am working in ASP and used a recordset to feed the min/max values from the SQL Min/Max commands. It worked out perfectly as my data changes ranges greatly from various time periods and a static min/max wouldn't work. The site is under construction, but you can see the chart at tetrarecycling.com. There is a small chart on the front, but click on the Silver Prices button to really check out the min/max in action.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...