Need an expert

[stulid]

Hi, im trying to do a bar chart for some time data, but the bars of the graph for the time that takes minutes are not appearing.

I figure its something im doing wrong with the data input in cells B,12,13,14+C,12,13,14


The figures are units of time

 

[jeffreybrown]

You are right, the problem is with those cells because they are not numbers

 

[stulid]

You are right, the problem is with those cells because they are not numbers

so what or how should I enter the data?

thanks.

 

[jeffreybrown]

I suppose what the numbers really mean. I know you said units of time, but a little more explanation would help.

Also, when you post a question, it is always a good idea to post the actual data, not a picture. We want to help, but it make it easier when we can copy and paste.

See my signature block for a method to display data

 

[stulid]

I suppose what the numbers really mean. I know you said units of time, but a little more explanation would help.

Also, when you post a question, it is always a good idea to post the actual data, not a picture. We want to help, but it make it easier when we can copy and paste.

See my signature block for a method to display data

The numbers that are not showing are minutes.seconds.then tenths/hundredths

 

[stulid]

Also, when you post a question, it is always a good idea to post the actual data, not a picture. We want to help, but it make it easier when we can copy and paste.

Heres the data - http://www.megaupload.com/?d=Z2IYBM3D

 

[jeffreybrown]

The numbers that are not showing are minutes.seconds.then tenths/hundredths

Surly not an expert...but, the problem seems to be a scaling issue.

As I see it, you would enter the number as 2:07.468 and this would be the correct entry for a number.

2:07.468 converted to a number is 0.00147532407407407 which is by far lower than any number you have in the list.

I formatted the number in the method I described above and then formatted the Horizontal Axis to show in a Logarithmic scale and the value show up.

In doing this, the last three numbers and the first three numbers show with the bar pointing in the opposite direction from the rest

 

[stulid]

Surly not an expert...but, the problem seems to be a scaling issue.

As I see it, you would enter the number as 2:07.468 and this would be the correct entry for a number.

2:07.468 converted to a number is 0.00147532407407407 which is by far lower than any number you have in the list.

I formatted the number in the method I described above and then formatted the Horizontal Axis to show in a Logarithmic scale and the value show up.

In doing this, the last three numbers and the first three numbers show with the bar pointing in the opposite direction from the rest

Well I have been using excel for about 1hour now, so I am just begging and have never touched it before.

Heres the data of the numbers from the program that generated them, two results from two peices of hardware,

http://i968.photobucket.com/albums/ae170/stulid/Untitled-31.jpg

 

[stulid]

anyone?

 

[stulid]

How do I get a Logarithmic scale along the Horizontal axis?

Can this graph be done using just the 1M and 32M values so the formatting and graph "look" right?