
Please don't take this as a critique.
In the book "MegaFox:1002 Things YouWanted to Know About Extending Visual FoxPro" by Marcia Akins they say...
"The default for the MSChart control is to plot the series in columns.
However, the default for MSGraph is to plot the series in rows! Since MSGraph is merely a
cutdown version of Excel’s graphing engine, one would expect Excel to plot the series in
rows as well. Surprisingly enough, the default for Excel is “best fit” and it plots the series from
whichever are fewer. So, If the data has more rows than columns, Excel uses the data from the
columns to create the series objects. Fortunately, the way in which the series are plotted is
configurable and can be controlled programmatically."
Way not implement this funcionality in FoxCharts ?



I am replying in Cesar's sted, as he's unavailable for a few days, recovering from eye surgery.
In recognition of this need you've identified, I have send him a new method for possible inclusion in FoxCharts which will take data series that are in rows and transform (transpose) them into a new cursor where the data is in columns.
I have every expectation that he will include this in an upcoming release.
BTW  he's says he's doing fine.
Jim Nelson



Thank you
That will be nice to facilitate the creation of graphs programmatically in response of the user’s choices in a program. That way we
can use cursors created with simple SQL statements directly.
Thanks again and continue the good work.
Best regards
From: jimrnelson [mailto:notifications@codeplex.com]
Sent: quintafeira, 6 de Agosto de 2009 15:17
To: ra3484202887303@tvtel.pt
Subject: Re: How FoxCharts plot the series ? "ala" Excel Way ? [VFPX:64669]
From: jimrnelson
I am replying in Cesar's sted, as he's unavailable for a few days, recovering from eye surgery.
In recognition of this need you've identified, I have send him a new method for possible inclusion in FoxCharts which will take data series that are in rows and transform (transpose) them
into a new cursor where the data is in columns.
I have every expectation that he will include this in an upcoming release.
BTW  he's says he's doing fine.
Jim Nelson



Hi,
Maybe I misunderstand you but FoxChart has the option to cluster the colums to your rquirements: Take e.g. the main chart example. chartype 11 is series in colums, charttype 8 is series in rows.
Regards,
Koen



Koen 
I believe that his request has to do with the data in the source cursor, not with how the data is displayed in a chart.
Jim



Hi Koen,
Try create a cursor, programmatically, in SQL with columns representing years and rows months like the tables in the examples, taking as source
the table structure I show in the posts. To do this you must have a second SELECT statement that transforms this cursor: “SELECT sum(month1), sum(month2)…,year from quotas where…” into something that Foxcharts can digest in a way that use it with all type
off graphs.
Original Select statement :
SELECT SUM(v_q_1)
as
Janeiro,SUM(v_q_2)
as
Fevereiro,SUM(v_q_3)
as
Março,SUM(v_q_4)
as
Abril,SUM(v_q_5)
as
Maio,SUM(v_q_6)
as
Junho,SUM(v_q_7)
as
Julho,SUM(v_q_8)
as
Agosto,SUM(v_q_9)
as
Setembro,SUM(v_q_10)
as
Outubro,SUM(v_q_11)
as
Novembro,SUM(v_q_12)
as
Dezembro,ano
FROM
quotas
INTO CURSOR
quotasano
WHERE BETWEEN(ano,2007,2009)
GROUP BY
ano
Then you must have a second select to transform this cursor into one with structure equal the examples. As I see I couldn’t create this cursor
directly in one statement.
Thanks and sorry if this explanation is bit confusion. I hope you understand mi point.
From: Koen [mailto:notifications@codeplex.com]
Sent: terçafeira, 11 de Agosto de 2009 8:15
To: ra3484202887303@tvtel.pt
Subject: Re: How FoxCharts plot the series ? "ala" Excel Way ? [VFPX:64669]
From: Koen
Hi,
Maybe I misunderstand you but FoxChart has the option to cluster the colums to your rquirements: Take e.g. the main chart example. chartype 11 is series in colums, charttype 8 is series in
rows.
Regards,
Koen



That’s right JimRNelson,
Try create a cursor, programmatically, in SQL with columns representing years and rows months like the tables in the examples, taking as source
the table structure I show in the posts. To do this you must have a second SELECT statement that transforms this cursor: “SELECT sum(month1), sum(month2)…,year from quotas where…” into something that Foxcharts can digest in a way that use it with all type
off graphs.
Original Select statement :
SELECT SUM(v_q_1)
as
Janeiro,SUM(v_q_2)
as
Fevereiro,SUM(v_q_3)
as
Março,SUM(v_q_4)
as
Abril,SUM(v_q_5)
as
Maio,SUM(v_q_6)
as
Junho,SUM(v_q_7)
as
Julho,SUM(v_q_8)
as
Agosto,SUM(v_q_9)
as
Setembro,SUM(v_q_10)
as
Outubro,SUM(v_q_11)
as
Novembro,SUM(v_q_12)
as
Dezembro,ano
FROM
quotas
INTO CURSOR
quotasano
WHERE BETWEEN(ano,2007,2009)
GROUP BY
ano
Then you must have a second select to transform this cursor into one with structure equal the examples. As I see I couldn’t create this cursor
directly in one statement.
Thanks and sorry if this explanation is bit confusion. I hope you understand mi point.
From: JimRNelson [mailto:notifications@codeplex.com]
Sent: quartafeira, 12 de Agosto de 2009 19:32
To: ra3484202887303@tvtel.pt
Subject: Re: How FoxCharts plot the series ? "ala" Excel Way ? [VFPX:64669]
From: JimRNelson
Koen 
I believe that his request has to do with the data in the source cursor, not with how the data is displayed in a chart.
Jim



Hi Aedaedg
To create a cursor for the Foxcharts, a fine example is given in the method CreateSampleCursors() in JN_sample2.
However not very clear to me what your main problem is, in the heading of this post you refer to an article of Marcia, which is all about
series in colums vz series in rows. What is your goal: columns or rows?
Regards,
Koen



Please try the following link:
http://dl.getdropbox.com/u/1637031/JRN_FoxCharts_Tools.zip
This is toolkit of mine for FoxCharts with two tools  one of which satisfies your request. I welcome your comments and suggestions on it.
I hope to be able to release this publicly soon, as part of the FoxCharts home page. This is a beta version; please give it a good try.
Jim Nelson

