ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How X-ax reflect correc time interval when don't have all points (https://www.excelbanter.com/charts-charting-excel/82950-how-x-ax-reflect-correc-time-interval-when-dont-have-all-points.html)

Narges

How X-ax reflect correc time interval when don't have all points
 
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.

Kelly O'Day

How X-ax reflect correc time interval when don't have all points
 
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.

...Kelly





"Narges" wrote in message
...
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.





All times are GMT +1. The time now is 10:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com