close

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.

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()