Hi.
I've got a spreadsheet with three columns and several thousand rows. I want to create a line graph with the date & time on the x axis and the values in columns B & C on the y axis.
Column A is a date and time field in the format "dd/mm/yyyy hh:mm:ss"
Columns B & C contain the data I want to chart.
Selecting all three columns and trying to create a chart from that creates a mess. It's something to do with column A.
If I leave column A out, it makes a line graph but I need the date & time in.
How can I edit column A so it works when I create a chart please?
The other issue is this data has one row per minute of time, so that's 1440 rows per day. Once I manage to get a line chart out of it, the x axis is going to be rammed with thousands of labels. I really have to have the text on the x axis cut right back to say, hourly marks or even less otherwise it's going to illegible.
How can I edit the axis labels to do this?
Many thanks in advance!
Donald Trump needs kicking out of a helicopter
Offset "(Emp) - a little heavy on the hyperbole."
Comments
Once you've created it you can then edit the axes to only show labels every 100 (or other number) data points
Offset "(Emp) - a little heavy on the hyperbole."
P.S. I used a Mac version, yours may have slightly different terminology
If you can share the file happy to take a look? But understand that you may not be able to if it's for work
Supportact said: [my style is] probably more an accumulation of limitations and bad habits than a 'style'.
(apols for camera caps - my excel is on the work machine but I can't upload pics direct from there)
Supportact said: [my style is] probably more an accumulation of limitations and bad habits than a 'style'.
There's several suggestions here so I'll do my best to give a combined response..
Here is a shot of part of the data:
And if I just select the data in columns B & C and insert a line chart, I get this.....
Offset "(Emp) - a little heavy on the hyperbole."
Offset "(Emp) - a little heavy on the hyperbole."
But I think you still need to use an xy type, not line for your dataset.
I've just tried what Sporky suggested - headers, scatter etc and it basically does the same thing!
Offset "(Emp) - a little heavy on the hyperbole."
Offset "(Emp) - a little heavy on the hyperbole."
Offset "(Emp) - a little heavy on the hyperbole."
Offset "(Emp) - a little heavy on the hyperbole."
e2a suggest delete graph, select data and insert graph for a fresh one.
As for "when am I ready?" You'll never be ready. It works in reverse, you become ready by doing it. - pmbomb