Chart: incorrect y-values plotted

[Pat Russell]

Hi,

Problem I just can't figure out, though I am a bit new to OWC.

Using a VBScript, which performs a lengthy set of calculations, and results
in 5 single-column arrays, each of which are all the same length (~600 rows).

The first array (arrDateList) is a list of consecutive days that I want to
use as my x-axis categories - this works fine.

The second array (PLAN_COST_AND_PROGRESS), contains percentage values. The
values are correct in this and the other calculated arrays - have checked
them in the browser as lists. However, I can't seem to plot this (or any of
the others) as a series correctly. If I remove all numberformatting (%) from
the y-axis then a line of the correct shape is displayed, but the values are
very wrong - starting at 0 and peaking at 30! I know that none of the values
in the array are greater than 1 (100%).

Does this sound at all familiar to anyone? It's driving me nuts...

Thanks, Pat.

 

[Thao Moua [ms]]

Can I see a sample of your code?

----------------------------------------------------------------------
Thao Moua
OWC Chartspace Support

This posting is provided "AS IS" with no warranties, and
confers no rights. Use of included script samples are
subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

 

[Pat Russell]

Hi,

Thanks for replying. I actually worked it out shortly after posting the
question, actually because I posted the question! The fact that the y-values
were out by a factor of 30 led me to thinking that it might be plotting
monthly rather than daily along the x-axis. To fix it, I changed the x-axis
grouping to None, and that solved the problem. Sounds simple, but with sparse
documentation it took a little while ;-)

Got another question for you if you've got some time... currently the page
that shows the chart can only return the chart picture (i.e. just binary
info) and I can't get it to display any html data alongside. So, I'm calling
the chart page from another page, but to write accompanying data on the page
I'm having to use session variables to pass the values back (these values are
calculated in the process of calculating the data for the chart). That's
okay, except that the first time I run the page, the session variables aren't
set, so I'm (almost) calling the chart code twice - once to get the data and
display it in html table without drawing the chart, and a second time to do
all the calculations again, and then draw the chart. It's really messy, and
slower, and it's probably because I'm a rank amateur, but would you have any
ideas? I'm at home at the moment, so I don't have access to the code, but I
can send it if it helps.

Are there any books on this stuff that you would recommend? I'm planning on
moving to .NET at some point, which seems to support more powerful charting
capabilities, but for the moment, OWC seems to have the best results.

Thanks for any help - I really like what you do on these discussion groups!

Pat.