A Challenging Charting Qustion - Are there any Brainiacs Among Us?

K

Ken Newberger

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
 
B

Bernard Liengme

It seems that people are having trouble understanding the problem - I am
Could you give same sample data?
best wishes
 
T

trip_to_tokyo

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Splitting Equals 2
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Finding totals withing a seven day period 9
Running calculation of a frequency 1
3-d referneces in chart series values 4
Multiple Challenging Excel needs.... 0
how to sum 'n' largest values *not* in an array? 7
Easy question: Sort ascending in a row? 3

Top