Excel help =[

[Blaaaaaaaah]

Does anyone know how to make a column graph with two y-axis on excel? I need two axis because I have two different variables with two different units (one is count, the other two bars are weight in grams) so they aren't supposed to be measured against the same axis.

But, I can't do it. I can only do it with column+line graphs in one, but I can't do it for just column graphs. =[

Minitab won't let me either.

Edit: You can add a secondary axis by selecting the bar I wanna make a secondary axis for and go format > Selected data series (or something) > axis > tick secondary axis.. but the bar overlaps the other two bars in a weird way when it's supposed to just stay where it is.

[lamchopz]

In the Options tab (in the window where you find you Axis tab), try playing around with the Overlap and Gap Width, at least you can make one series fatter (by reducing the Gap Width) and so it is easier to distinguish the two.

[Blaaaaaaaah]

Yeah, I did that.. but I get why they did it now, because won't really be able to tell which column is supposed to be read by which..

[lamchopz]

actually, no. it's the convention of data representation in science.

you're not meant to represent two sets of data of different units on the same graph/chart because it does not show any comparison (I take it you're trying to show some relation between the two series).

if you want to demonstrate the trend, you might want to put the two graphs one after the other, or side by side.

but as far as the technical details of putting two vertical axes in Excel go, I have no idea apart from the fattening of one column series or ... sketching by hand.

[Blaaaaaaaah]

Oh~ Well actually... mine wasn't really two different units. One had units (grams) and one didn't have units (e.g. number of leaves). I don't think excel lets me do it so I just left it, I can't be stuffed anymore Dx

[lamchopz]

well, usually what is see is that the y-axis has to be the same unit for all series (for example, diastolic blood pressure, systolic blood pressure, mean arterial pressure in mmHg vs. time in minutes).

but since it's your report, if you represent it in a stunning way that fully captures everything in one graph, i don't see why not. xD

but don't take my word for it, though.

what exactly are you trying to graph? o.o

[Blaaaaaaaah]

Just showing a simple relationship between shoot formation and weight. The higher number of shoots, the heavier the weight.

Second thoughts I might as well put the weight as a line graph. /shrugs

[lamchopz]

haha yea, line graph would do and is best because it simplifies the pproblem.

[lamchopz]

though i think line of best fit would be more appropriate in this case.

[Blaaaaaaaah]

Nah, the lack of values make line of best fit inappropriate.