Terrible graphs

Get your science fix here: research, quackery, activism and all the rest
User avatar
Sciolus
Clardic Fug
Posts: 175
Joined: Mon Nov 11, 2019 6:42 pm

Re: Terrible graphs

Post by Sciolus » Wed May 20, 2020 10:13 am

I don't think Excel can do that thing with the x-axis labels being in two rows. If the labels are long, you have to put up with overlapping labels or change the angle of them. You might be able to do it by putting in hard line-breaks manually, but that's hard work and definitely means it wasn't done innocently.

User avatar
Bird on a Fire
After Pie
Posts: 1961
Joined: Fri Oct 11, 2019 5:05 pm
Location: with the birds

Re: Terrible graphs

Post by Bird on a Fire » Wed May 20, 2020 1:11 pm

Martin_B wrote:
Wed May 20, 2020 9:15 am
Bird on a Fire wrote:
Tue May 19, 2020 6:25 pm
jimbob wrote:
Tue May 19, 2020 5:50 pm


It would be straightforward to get that in Excel, but you'd need to actually put in effort to get that - by sorting the data in descending order.

It would be very difficult to do that accidentally.
Although, somebody might make a graph, then sort the cells to look at the data, without realising that the graph would be automatically updated to the new order, and then not check it. Excel doesn't always handle dates well either.
Excel handles dates better than that, though. Again, it would require sorting the data into descending order and then plotting
Only if it recognises them as dates. If it thinks they're text they get treated as categories.

It could also have been plotting, and then sorting the data.

User avatar
Bird on a Fire
After Pie
Posts: 1961
Joined: Fri Oct 11, 2019 5:05 pm
Location: with the birds

Re: Terrible graphs

Post by Bird on a Fire » Tue May 26, 2020 4:30 am

And now, this
Attachments
dohqa8l94kb41.png
dohqa8l94kb41.png (138.4 KiB) Viewed 8 times

Post Reply