I am trying to create a plot that uses x-axis values of time. Most data
points are in one-hour increments, but a few are only minutes apart (e.g. -
1:00; 2:00; 3:00; 3:01; 4:00). The x-axis scaling assigns them all equal
charting values (i.e. - they all reside an equal distance from one another).
Is there an easy way to assign their actual values to the chart?

Which chart type?

Which EXCEL version?


"todd" wrote:

I am trying to create a plot that uses x-axis values of time. Most data
points are in one-hour increments, but a few are only minutes apart (e.g. -
1:00; 2:00; 3:00; 3:01; 4:00). The x-axis scaling assigns them all equal
charting values (i.e. - they all reside an equal distance from one another).
Is there an easy way to assign their actual values to the chart?

Microsoft Office Excel 2007

"trip_to_tokyo" wrote:

Which chart type?

Which EXCEL version?


"todd" wrote:

I am trying to create a plot that uses x-axis values of time. Most data
points are in one-hour increments, but a few are only minutes apart (e.g. -
1:00; 2:00; 3:00; 3:01; 4:00). The x-axis scaling assigns them all equal
charting values (i.e. - they all reside an equal distance from one another).
Is there an easy way to assign their actual values to the chart?

I can give you an XY Scatter chart with exact times running up the Y axis.

Is this any good for you?

You might be able to play around with it to see if you can get it to do
exactly what you want it to do.



"todd" wrote:

Microsoft Office Excel 2007

"trip_to_tokyo" wrote:

Which chart type?

Which EXCEL version?


"todd" wrote:

I am trying to create a plot that uses x-axis values of time. Most data
points are in one-hour increments, but a few are only minutes apart (e.g. -
1:00; 2:00; 3:00; 3:01; 4:00). The x-axis scaling assigns them all equal
charting values (i.e. - they all reside an equal distance from one another).
Is there an easy way to assign their actual values to the chart?

Actually, I'm creating an environmental stress profile having two y-axis
values (temperature and voltage - with different scales); and time in the
x-axis. There are short periods of time where the temp and voltage
transition; and long periods of time between. So I want the plot to show
that information accurately (i.e. - steep transitions).

"trip_to_tokyo" wrote:

I can give you an XY Scatter chart with exact times running up the Y axis.

Is this any good for you?

You might be able to play around with it to see if you can get it to do
exactly what you want it to do.



"todd" wrote:

Microsoft Office Excel 2007

"trip_to_tokyo" wrote:

Which chart type?

Which EXCEL version?


"todd" wrote:

I am trying to create a plot that uses x-axis values of time. Most data
points are in one-hour increments, but a few are only minutes apart (e.g. -
1:00; 2:00; 3:00; 3:01; 4:00). The x-axis scaling assigns them all equal
charting values (i.e. - they all reside an equal distance from one another).
Is there an easy way to assign their actual values to the chart?

Make an XY chart, which will show the times proportionally. A line chart
spaces them equally regardless of value.

In 2007 you'll have to convert times to fractions (24 hours = a whole
day, so 12 hours = 0.5 etc.) in order to enter them as scale parameters.
Previous versions were smart enough to accept times or dates in the dialogs.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 3/17/2010 3:21 PM, todd wrote:
I am trying to create a plot that uses x-axis values of time. Most data
points are in one-hour increments, but a few are only minutes apart (e.g. -
1:00; 2:00; 3:00; 3:01; 4:00). The x-axis scaling assigns them all equal
charting values (i.e. - they all reside an equal distance from one another).
Is there an easy way to assign their actual values to the chart?