Different length of values for X axis

Hi everyone. So, I have some very long csv files with logs every 5 secs approximately for about 2 days and I want to put them in a graph. The problem is that the X axis is a mess with all those values. Now, I can easily create a new column with values from 0 to 48 hours for example. But how can I tell Excel that it needs to show all the data point with that different range of values for the X axis?

Originally Posted by MrShorty

I am having difficulty visualizing the problem. What chart type are you using? Are the times in the text file being imported as text or as real date/time values? Can you post a sample file with the existing chart that illustrates the problems you are having and what you would like to do differently?

Hi. Here is an example I've made (without real data). What I'd like is to have a graph that shows the trend in time, but I'd like the numbers from 0 to 48 on the X axis instead of the whole range, but with the entire data set correctly divided. Suggestions?

Originally Posted by MrShorty

I could not find a chart in your sample file, so I am still not sure what you have tried. If I understand what you are trying to do, I would expect to:

1) Add a column to convert the seconds data in column A to hours =A2/3600 or =CONVERT(A2,"sec","hr")
2) Insert a scatter chart that uses the time in hours column for the x values and the data column for the y values. If you leave the time in hours column in column C and the data in column B, then you will need to create the chart with whatever Excel guesses, then edit the data series in the Select Data dialog to get the x and y values correctly assigned.
3) Any formatting you want to add.

That should work, assuming I understand what you are trying to do. If I am not understanding, then please explain what you are trying and what you want different.

Here's the file. The A column is seconds and goes on the X axis. I'd like that axis to be something like 0,20,40,60,80 mins and that's it, but I don't know how to properly format that axis

Hi Mikla

I've taken your sample and added a column to round each second value to a number of minutes then used that as the axis markers and set it to a date axis rather than text, this then allows you to control how many values to include. in the attached I've set it to show every 10th value. this can be changed in the axis format for your graph

Ron