Thread: x-axis scaling
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Todd Todd is offline
external usenet poster
 
Posts: 177
Default x-axis scaling

Thanks David. The only thing I noticed was that X-Y does not have the
"Hidden and Empty Cell Settings"\"Connect data points with line" option; so I
needed to create a huge data worksheet with minutes between all data points,
and a y value for each x value.

"David Biddulph" wrote:

You got the answer in .charting
Use XY, not a line chart.
--
David Biddulph


"todd" wrote in message
...
I posted this in "Charts", and want to expand it to "General Questions" -
I've only received one response. I am trying to create a plot that uses
x-axis values of time, using "Microsoft Office Excel 2007". 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
x-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?


.