Creating a range out of a scattered cells with MFC Excel automation
in [MFC]
|
From: dushkin on 3 Feb 2010 06:27 Hello all. I need to create a chart from 2 columns, but not from all of the cells in them. For example: If I need to create a line chart out of the date in colums A and D, then I know that I should use Union to create a joint range of A and D and pass it to to ChartWizard function. But what I realy need is to create the chart out of A and D columns data only if the data in column C for example, is "valid data" . How can I do this? Thanks!
From: Joseph M. Newcomer on 3 Feb 2010 08:51 Probably by buying a third-party plotting library. Excel is notorious for how bad its charting mechanisms are, particularly the fact that "broken data" doesn't produce good charts. They have this unfortunate presumption that all data points are collected all the time. I've had Excel experts teach me entirely new words (how to swear in at least two other languages) trying to get decent charts with broken data. Often, I find that an X-Y scatter chart compensates best for this problem, and in the new Excel, you can get lines connecting the points quite easily. It isn't quite right, but it is all we've got. joe On Wed, 3 Feb 2010 03:27:51 -0800 (PST), dushkin <taltene(a)gmail.com> wrote: >Hello all. > > I need to create a chart from 2 columns, but not from all of the >cells in them. > > For example: > > If I need to create a line chart out of the date in colums A and D, >then I know that I should use Union to create a joint range of A and D >and pass it to to ChartWizard function. > > But what I realy need is to create the chart out of A and D columns >data only if the data in column C for example, is "valid data" . > > How can I do this? > >Thanks! Joseph M. Newcomer [MVP] email: newcomer(a)flounder.com Web: http://www.flounder.com MVP Tips: http://www.flounder.com/mvp_tips.htm
From: dushkin on 3 Feb 2010 09:54 On 3 פ×ר××ר, 15:51, Joseph M. Newcomer <newco....(a)flounder.com> wrote: > Probably by buying a third-party plotting library.  Excel is notorious for how bad its > charting mechanisms are, particularly the fact that "broken data" doesn't produce good > charts.  They have this unfortunate presumption that all data points are collected all the > time.  I've had Excel experts teach me entirely new words (how to swear in at least two > other languages) trying to get decent charts with broken data.  Often, I find that an X-Y > scatter chart compensates best for this problem, and in the new Excel, you can get lines > connecting the points quite easily.  It isn't quite right, but it is all we've got. >                     joe > > > > > > On Wed, 3 Feb 2010 03:27:51 -0800 (PST), dushkin <talt...(a)gmail.com> wrote: > >Hello all. > > > I need to create a chart from 2 columns, but not from all of the > >cells in them. > > > For example: > > > If I need to create a line chart out of the date in colums A and D, > >then I know that I should use Union to create a joint range of A and D > >and pass it to to ChartWizard function. > > > But what I realy need is to create the chart out of A and D columns > >data only if the data in column C for example, is "valid data" . > > > How can I do this? > > >Thanks! > > Joseph M. Newcomer [MVP] > email: newco...(a)flounder.com > Web:http://www.flounder.com > MVP Tips:http://www.flounder.com/mvp_tips.htm-×סתר ××§×¡× ×צ×××- > > -×ר×× ××§×¡× ×צ×××- Thanks Joseph for the reply. But my question is actualy about the automation process. How to create programmaticaly the correct range of scattered (or broken) cells to pass to the function ChartWizard ? I know there is the _Application.Union method, but is this what I am looking for? I tried to put 4 ranges as arguments but the compiler shouted. Thanks!
From: dushkin on 4 Feb 2010 02:59 On 3 פ×ר××ר, 16:54, dushkin <talt...(a)gmail.com> wrote: > On 3 פ×ר××ר, 15:51, Joseph M. Newcomer <newco...(a)flounder.com> wrote: > > > > > > > Probably by buying a third-party plotting library.  Excel is notorious for how bad its > > charting mechanisms are, particularly the fact that "broken data" doesn't produce good > > charts.  They have this unfortunate presumption that all data points are collected all the > > time.  I've had Excel experts teach me entirely new words (how to swear in at least two > > other languages) trying to get decent charts with broken data.  Often, I find that an X-Y > > scatter chart compensates best for this problem, and in the new Excel, you can get lines > > connecting the points quite easily.  It isn't quite right, but it is all we've got. > >                     joe > > > On Wed, 3 Feb 2010 03:27:51 -0800 (PST), dushkin <talt...(a)gmail.com> wrote: > > >Hello all. > > > > I need to create a chart from 2 columns, but not from all of the > > >cells in them. > > > > For example: > > > > If I need to create a line chart out of the date in colums A and D, > > >then I know that I should use Union to create a joint range of A and D > > >and pass it to to ChartWizard function. > > > > But what I realy need is to create the chart out of A and D columns > > >data only if the data in column C for example, is "valid data" . > > > > How can I do this? > > > >Thanks! > > > Joseph M. Newcomer [MVP] > > email: newco...(a)flounder.com > > Web:http://www.flounder.com > > MVP Tips:http://www.flounder.com/mvp_tips.htm-×סתר ××§×¡× ×צ×××- > > > -×ר×× ××§×¡× ×צ×××- > > Thanks Joseph for the reply. > > But my question is actualy about the automation process. > > How to create programmaticaly the correct range of scattered (or > broken) cells to pass to the function ChartWizard ? > I know there is the _Application.Union method, but is this what I am > looking for? I tried to put 4 ranges as arguments but the compiler > shouted. > > Thanks!-×סתר ××§×¡× ×צ×××- > > -×ר×× ××§×¡× ×צ×××- Well, I guess the best way is to do the following: RNGt = Union(r1,r2) RNGt = Union(RNGt, r3) RNGt = Union(RNGt, r4) etc... Hope that will work...
|
Pages: 1 Prev: CMultiDocTemplate and RUNTIME_CLASS. Next: here is the answer: |