Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
x-axis scaling
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
x-axis scaling
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
x-axis scaling
No multiple axes, either. I think I may use Matlab to plot. Thanks again.
"todd" wrote: 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? . |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
x-axis scaling
XY is pretty flexible. If you can't find how to do what you want with the
chart in Excel 2007, you may find it easier to switch back to Excel 2003. You certainly don't need to fill in the gaps as you described. -- David Biddulph "todd" wrote in message ... 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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
x-axis scaling | Charts and Charting in Excel | |||
different y-axis auto scaling... | Charts and Charting in Excel | |||
Scaling axis | Charts and Charting in Excel | |||
axis scaling | Charts and Charting in Excel | |||
Scaling x-axis with time | Charts and Charting in Excel |