It looks like you're new here. If you want to get involved, click one of these buttons!
Subscribe to our Patreon, and get image uploads with no ads on the site!
Base theme by DesignModo & ported to Powered by Vanilla by Chris Ireland, modified by the "theFB" team.
Comments
Offset "(Emp) - a little heavy on the hyperbole."
Supportact said: [my style is] probably more an accumulation of limitations and bad habits than a 'style'.
Offset "(Emp) - a little heavy on the hyperbole."
But if you want to understand it better.... what’s happening here is it’s reading the red section as your data name, and a20:b20 and c20 as data.
The biggest issue is that Excel can't show times on an axis when it sees col A as Date-Time, it needs to know you want it represented as Time alone. I suspect this is because showing minute-wise data across multiple days isn't good practice for large data sets like this.
Offset "(Emp) - a little heavy on the hyperbole."
Doing what you've detailed above; Select Data, edit Horizontal Axis Labels to the A column data, then clicking on 'Remove' in the left box deletes everything - including the edited right box contents.
Offset "(Emp) - a little heavy on the hyperbole."
Offset "(Emp) - a little heavy on the hyperbole."
Put the number 1 into a spare cell
Copy it
Then do Paste Special>Multiply
As for "when am I ready?" You'll never be ready. It works in reverse, you become ready by doing it. - pmbomb
Success!!
Thank you Drofluf!
How the hell did you find that out?
Offset "(Emp) - a little heavy on the hyperbole."
I expect importing that into the latest Excel was a less than perfect operation.
Strange - I tried setting the cell formats to number and that didn't help but doing what you did fixed it.
Offset "(Emp) - a little heavy on the hyperbole."
As for "when am I ready?" You'll never be ready. It works in reverse, you become ready by doing it. - pmbomb
Offset "(Emp) - a little heavy on the hyperbole."
CSV was always the path of least resistance!!