Timeline chart

[lucian81]

Hello,

I want to create a chart (using mschart20lib) that has to following axis:
- Y axis - values between -2 and 2
- X axis - the date when the value was measured

i.e.
DATE: Value:
30.11.2007 -2
30.12.2007 2
01.06.2008 -1

I have managed to create the chart, but I could not be able to show the timeline correctly - the distances between the X axis values is equal for each time interval. This is not correct, because between 30.11.2007 and 30.12.2007 is aprox. 1 month and between 30.12.2007 and 01.06.2008 there are 6 months.

I tried to insert between these main intervals daily values calculated so that they do not change the straight line. But the mschart20lib is displaying all these values, which is also not correct for me.

Do you have an idea how to solve this?

Thank you.

Regards,
Lucian

 

[DSummZZZ]

I'm sure you're using VFP somewhere or you wouldn't be asking in this forum, but how is this a VFP question?


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[lucian81]

The application is written in VFP 9. I am using mschart20lib to display the charts.

I think that this should be solved somehow by populating differently the data arrays or by using differently the chart component.

 

[Mike Lewis]

Hi Lucian,

I think you're asking too much of MSChart. You and I know that it's a timeline, but as far as the control is concerned, it's just another line chart. It has not way of knowing you want your X-axis intervals to be other than equi-distant.

Unless someone can come up with a solution, I think you're going to have to find another charting control.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[lucian81]

Hi Mike,

I am starting to believe it's true that I am asking too much from this chart control. But my application is build around this solution and it is rather late to modify it so radicaly. Maybe in the next version.

I tried to insert between these main intervals daily values calculated so that they do not change the straight line. Can I display only the labels I am interested on?

Thank you again.
Lucian

 

[cricket]

Excel Chart has the functionality you need.
(see Chart--> Chart options-->Axes.)

Set up a template in Excel, save your VFP data to an XLS file, and copy & paste (or link) into Excel.

 

[lucian81]

But this would mean that Excel should be installed on the client's computer, isn't it true?