Excel Help

[BadPvtDan]

I know have some Excel masters in here so perhaps someone has an answer.

I have repeated measurements but I don't want to see an average.

Three major categories (sodas) and three sub-categories (candies). Each combination is tested three times and I want to display each measurement (not the total or average).

When I do a regular column chart it displays them all but it puts every name combination at the bottom...and looks really busy. When we do a pivot chart we put the candy as a legend field, soda as an axis field and height as a value...it's perfect but we have to choose an average or a total instead of every single measurement.

I have attached the data for your perusal. Thanks guys!

[kungfuman]

Here's some ideas, just take your pick (and delete the rest).

If you don't like the grouped or 3D charts, the last chart is probably closest to what you originally had in mind. I used the first set of data for this chart, broken down candy then soda. You might prefer to do a similar chart using the second set of data that I have broken down by soda then candy.

If the x-axis is too busy, you can change that by doing two things:

1. Go to the set of data in the top left corner of the spreadsheet, go to the "soda" column, and clear the first and third entries for "diet coke". Do the same with "root beer", then "club soda" etc. all the way down to the bottom of the table at row 28. The column will now read

[space]
diet coke
[space]
[space]
root beer
[space]
[space]
club soda
[space]
[space]
etc.

2. Double click on the x-axis to get into the "format axis" menu. Go to the "scale" tab. In here, you can change the "tick mark" spacing to one tick every 3 categories. Probably the third box down (it's currently set at "1").

HTH

Dan

ps. Thank you, admin, for letting me attach files to posts again

[BadPvtDan]

Hey Dan,

Danny's wife here - thank you, thank you, thank you!! I've never been good with graphics in Excel and it never seems to want to do what I think is pretty common sense. I was able to look through your examples and understand what you did to get it set up. Really appreciate the help!!! I was about to program the damn things in SAS.

~Melissa

[kungfuman]

Glad to be of assistance!

[MIKE JG]

First female to ever post on here.....

[BadPvtDan]

First female to ever post on here.....

Yeah but it's just my wife...not the same...for me at least.