~~~excel~pie~clock~misery~~~

Message Bookmarked
Bookmark Removed
(Someone already explained to me how to do this but I forget and suddenly I need to be able to very very very quickly and I am giant luddite)

I have to use excel to make a pie-chart which represents one-hour of random radio station output, so each segment of pie chart represents something like "news" or "adverts" or "[RECORD X]" or something like this. Assume that the radio-hour in question starts on the hour (because it did/does). I have made two columns in excel to represent minutes-past-hour and radio-content, so first row is something like "0 - adverts" and the next is "3 - news" and stuff and stuff and everything up to "60 - schadenfreude-y chat" etc etc.

IF I highlight both columns and press the pie-chart button, the chart it creates puts the segments in order of size. How do I make it put the data/segments in the order that I want?

There is far too much background information here and also I suspect there is already a thread for such boringy computery questions but, y'know, this is a bit pressing. Please please help I love you (love you).

Alex in Doncaster (Alex in Doncaster), Wednesday, 29 October 2003 23:01 (twenty-two years ago)

fuck fuck help help. my pie-chart is just a LINE. Apparently there is some very straightforward way to sort the data. I, y'know, BESEECH you. thanks.

Alex in Doncaster (Alex in Doncaster), Wednesday, 29 October 2003 23:38 (twenty-two years ago)

I'm sorry Alex, I only know the basics of Excel.

Nicolars (Nicole), Wednesday, 29 October 2003 23:40 (twenty-two years ago)

Alex,

Convert your measurement into a time/date format (eg: "29/10/03 12:03:00"). That should solve your problem.

Good luck!

Dan

gygax! (gygax!), Thursday, 30 October 2003 00:21 (twenty-two years ago)

I meant.... Good luck Alex! I have no idea why I called you Dan!!!

gygax! (gygax!), Thursday, 30 October 2003 00:21 (twenty-two years ago)

I try this now. Beholden gygax. Marvel at how this solution eluded me ENTIRELY.

Alex in Doncaster (Alex in Doncaster), Thursday, 30 October 2003 00:28 (twenty-two years ago)

hahahah BUSTED!

hstencil, Thursday, 30 October 2003 00:28 (twenty-two years ago)

No problem Dan Alex, you're very welcome.

I'm available for all future Excel/Access queries sporadically between the hours of 07:30-18:30 Monday-Thursday and 7:30-13:00 on Friday, Pacific Standard Time.

gygax! (gygax!), Thursday, 30 October 2003 00:34 (twenty-two years ago)

Gygax did a whoopsie on the carpet!

Casuistry (Chris P), Thursday, 30 October 2003 02:57 (twenty-two years ago)

five months pass...
http://www.physics.ubc.ca/~gmarsden/ft_sumner_2003/rollout/images/002_BLAST_conference.jpg

Dada, Monday, 5 April 2004 18:43 (twenty-one years ago)


You must be logged in to post. Please either login here, or if you are not registered, you may register here.