Table Evaluation

Hi there. Am a new member here and I wish to find out about some ways
of charting these evaluation that I have.

For example, I have this table:

W(10%) X(10%) Y(10%) Z(5%) Total Score(35%)

A 10, 8, 6, 5,
29
B 9, 5, 6, 3,
23
C 10, 9, 6, 5,
30
D 7, 3, 6, 5,
21

I have already made a chart(bar graph) for the total score.

Now what I want to do next is to make a chart evaluation on columns X
and Y sub-totalling to 20%, but still based on the total score of 35%.
It's like this table is a portion of a pie. (But am still making this
chart as bar graph.)

What happens is that if I chart the columns X and Y, it bases itself on
a total score of 20%.

I hope I am making myself clear. I don't know how to explain it more
technically.

Thanks so much in advance.


---
Message posted from http://www.ExcelForum.com/

It's not really clear what you're asking for. Do you just want to set
your Y maximum to 35? Double click on the axis, click on the Scale tab,
set the maximum, and keep the Auto box unchecked.

Are you making a stacked bar chart?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

afo wrote:

Hi there. Am a new member here and I wish to find out about some ways
of charting these evaluation that I have.

For example, I have this table:

W(10%) X(10%) Y(10%) Z(5%) Total Score(35%)

A 10, 8, 6, 5,
29
B 9, 5, 6, 3,
23
C 10, 9, 6, 5,
30
D 7, 3, 6, 5,
21

I have already made a chart(bar graph) for the total score.

Now what I want to do next is to make a chart evaluation on columns X
and Y sub-totalling to 20%, but still based on the total score of 35%.
It's like this table is a portion of a pie. (But am still making this
chart as bar graph.)

What happens is that if I chart the columns X and Y, it bases itself on
a total score of 20%.

I hope I am making myself clear. I don't know how to explain it more
technically.

Thanks so much in advance.


---
Message posted from http://www.ExcelForum.com/