Prev: constant value in a chart
Next: Indicating lines from data labels to pie chart segments
From: trip_to_tokyo on 27 Nov 2009 16:47
Hi Bernard, I can see what Ken is saying and have drawn a picture for you at:-

http://www.pierrefondes.com/

(item number 21).

I do not know if this can be done in EXCEL though (I can see what he wants
but do not know how to do it).



"Bernard Liengme" wrote:

> It seems that people are having trouble understanding the problem - I am
> Could you give same sample data?
> best wishes
> --
> Bernard Liengme
> http://people.stfx.ca/bliengme
> Microsoft Excel MVP
>
> "Ken Newberger" <KenNewberger(a)discussions.microsoft.com> wrote in message
> news:6A26F5F9-C9F4-49CB-A4D5-A5DD1137D4C7(a)microsoft.com...
> > I have 10 columns of data.
> > Columns 1 and 2 refer are two scores that refer to one category.
> > Columns 3 and 4 are two scores that refer to another category, etc.
> > There are five categories in all.
> >
> > What I would like to do is to show a graph of 5 columns. Within each
> > column, I also want to reflect the two cumulative scores for each
> > graphical
> > column. If the two scores are 3 and 7, the column should be as tall as 10
> > (with a color division of the two scores of 3 and 7 within the column),
> > and
> > so on for all five columns.
> >
> > Can this be done, and if so, how?
> >
> > Thanks so much!!!
> >
> > Ken
>
> .
>
 | 
Pages: 1
Prev: constant value in a chart
Next: Indicating lines from data labels to pie chart segments