Home

Keeping two columns paired when putting then on a graph

Highlighted
Occasional Visitor

How do I get the two columns paired next to each other in the graph. I am trying to do a comparison on the cows weight and the weaning weight of their calf. But to compare them in a graph I need to keep the two numbers to stay paired together but show in two bars on the graph. Like in bar one the 11 cows in bar one. I need a column next to it showing the wean weight of those 11 cows calf  then same thing for the rest of the bars. How do I do that?excel help.GIF

1 Reply
Highlighted
You mean you need the average wean wt of the calves from the 11 cows in the bin of 900-999 pounds? You could use the AVERAGEIFS function for that purpose