x-axis scaling

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?
 
T

todd

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top