I need to reflect correct time intervals in my chart i.e. 15,30,60,120
minutes. I have different treatment groups and measure a specific value at
each time point but I don't measure at all time points i.e. I measure
0,15,30,45,60,90,120,180 ect. The time has to be on X-Axis but at the
moment, all time points I have are treated the same and don't reflect correct
interval i.e. the distance between 15-30 on X-Axis is the same as the
distance between 60-120 min.
I use excel 2003 version.
Narges
It sounds like you are using a Line chart, not an XY (Scatter) chart.
To get your X axis time period to plot dimensionally, switch to an XY Chart
Type.
To change your chart type, just right click your chart,select Chart Type and
then XY (Scatter) chart.
...Kellyquot;Nargesquot; gt; wrote in message
...
gt;I need to reflect correct time intervals in my chart i.e. 15,30,60,120
gt; minutes. I have different treatment groups and measure a specific value
gt; at
gt; each time point but I don't measure at all time points i.e. I measure
gt; 0,15,30,45,60,90,120,180 ect. The time has to be on X-Axis but at the
gt; moment, all time points I have are treated the same and don't reflect
gt; correct
gt; interval i.e. the distance between 15-30 on X-Axis is the same as the
gt; distance between 60-120 min.
gt; I use excel 2003 version.
- Jul 25 Fri 2008 20:45
How X-ax reflect correc time interval when don't have all points
close
全站熱搜
留言列表
發表留言
留言列表

