x-axis scaling
in [Charts]
|
Prev: I'm looking to great a multi month fundraiser temperature graph.
Next: Why do my pie charts have labels which say "add text"?
From: todd on 17 Mar 2010 15:21 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?
From: trip_to_tokyo on 17 Mar 2010 15:39 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?
From: todd on 17 Mar 2010 15:48 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?
From: trip_to_tokyo on 17 Mar 2010 16:05 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?
From: todd on 17 Mar 2010 16:30
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? |