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.

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.

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

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

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.

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

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.