Skip to Navigation | Skip to Content

Forums

Graphing, Bar Charts

Mar 6 2007 at 1:48 pm

stratacus9

anyways to make it graph columns over rows?

i.e.
size weight height
A 10 400 50
b 12 200 30

right now it graphs:

10 400 50 12 200 30
a b

would be better for me to graph

10 12 400 200
a b a b

etc.

jeffrey.

Mar 6 2007 at 7:54 pm

esan

Hi

Sorry for the late reply,

You'll have to transpose the data manually before inputting it to the bar graph since it can only plot it by columns as you said.
So instead of sending

size weight height
A 10 400 50
B 12 200 30

Sending

Metric A B
Size 10 12
Weight 400 200
Height 50 30

to the bar graph will give you what you wanted.
There are a number of ways to have proto transpose the entryset automatically for you. This module http://www.protosw.com/mods/lib/view/132 does a transpose, or as aron suggested in another reply, the vba module is always an option.

Hope this helps.

 
Already using Proto? Log In | Register