x-axis scaling

  • Thread starter Thread starter todd
  • Start date Start date
T

todd

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?
 
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.
 
Back
Top