Bipolar Graph

Terrysdelight

Hi


School homework!!


Can anyone tell me how/where I can learn to do a 'Bipolar Graph'. I'm guessing it should be in Excel but I've had a look and can't find anything.


Many thanks
Terrysdelight

grumbler

Is it not just a usual column or bar chart?

Terrysdelight

grumbler wrote: »

Is it not just a usual column or bar chart?

I've been looking at various images on line and yes, examples do include columns and bars - both above the line and below the line (positive and negative - up and down, so I guess this is why it's called bipolar).


We need to know how to record the data in excel - then I guess it will just be a case of highlighting text and the graph/wizard will do the rest?

gunte

or side by side

grumbler

Try doing this as two series: one for positive numbers and another for negative.

Terrysdelight

I've found the graphs, but I'm just now sure how he should be recording his data in the spreadsheet.


It's a ruddy environmental study with 15 questions and a range of 5 answers.

Terrysdelight

Finally worked it out. Son wasn't recording data correct. Once he changed data to positive and negative numbers, the bars, went up and down as they should.


Phew.....