Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I would like to create a chart which shows a series of numbers in minutes and
seconds (to the hundreths of a second) that correlates to another column, also measured in minutes and seconds(and also to the hundreths of a second) by a factor of 0.93567448724. For example, the first column will start with 16:00.00 and the second column will have 14:58.25, which is 0.93567448724 times as large as 16:00.00. I've tried to use the forumla of A*B, where A is the number 16:00.00 and B is the constant 0.93567448724, but it doesn't seem to work. Any help will be greatly appreciated. Thanks. Eli -- I will do today what you won''t, so tomorrow I can do what you can''t. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using functions to correlate data | Excel Worksheet Functions | |||
how to plot column chart with one series against multiple series. | Charts and Charting in Excel | |||
Can I correlate 4 arrays e.g =correl(C7:C21,D7:D21,E7:E21,F7:F21 | Excel Worksheet Functions | |||
Series Numbers row & column | Excel Discussion (Misc queries) | |||
how do I change a line series to a column series in excel? | Charts and Charting in Excel |