Charting binary numbers

[justin27]

I have data that is taken at binary states

Colunm A Colunm B
0000 20mv
0001 40 mv
0010 60 mv

I can't seem to chart this in Excel.
Any Ideas?

Justin

 

[rb1957]

i guess it depends on what you want to show !

i expect that you want to make a scatter plot of the base ten equivalent of column A and chart column B as the y-coord.

or you could plot column A as a "category" using a line chart ... but i think you'd need to have a complete listing of column A (you wouldn't be able to miss numbers), by insering missing numbers if needed (with 0 in column B).

good luck

 

[IRstuff]

Create a separate column, and use BIN2DEC function against column A to convert to decimal integers and plot against that set of numbers

TTFN