inputting binary data into excel and graphing it...help?

[shiek]

Hey there,

I want to graph some values whose x-axis is a binary pattern, however, i cant find where to specify that this is binary in excel so when i graph my values, it puts them on a ten-based x-axis.

anyone know how to tell excel that this column is binary?

thnk you

 

[IanG]

I think you're going to have to use the bin2dec funtion in another column to generate a base10 value which excel will then be able to chart. You might have to use text boxes for the scale on your chart, although if you format the column of binary numbers as text they might show up ok.

If your binary data is in column A, create a formula =BIN2DEC(a1) in another column and copy/paste it down.

 

[shiek]

sounds good, ill give it a shot