Any M$ Excel (Office 2007) gurus out there?

Off topic discussion zone.

Moderators: winston, another_commander, Cody

Post Reply
User avatar
DaddyHoggy
Intergalactic Spam Assassin
Intergalactic Spam Assassin
Posts: 8515
Joined: Tue Dec 05, 2006 9:43 pm
Location: Newbury, UK
Contact:

Any M$ Excel (Office 2007) gurus out there?

Post by DaddyHoggy »

If yes read on:

Firstly, I'm sure this used to work in Office 97's version of Excel.

My problem - student feedback for a course is broken down per lecture (20 of them) as "Too much" "Just Right" "Too Little" (Technical content).

This data is displayed as a Stacked 3D columns with the hope that the data shows a nice big section of "Just Right" in the middle of some tail ends top and bottom of the other two.

So we can compare year on year improvements (or lack of them) for each lecture (and therefore each lecturer) the hope was to put data from previous years as a duplicate set of columns in front of the current year's data.

This used to be straightforward (I recall) in Office 97, but no amount of cursing, crying, dragging, dropping, adding, fiddling with chart/data ranges is getting the chart to do what I want it to do in Office 2007.

My Google-fu has also failed me and I can't find a solution, so I thought I'd try "Oohay!"

Any thoughts, solutions, URLs would be much appreciated.

DH
Selezen wrote:
Apparently I was having a DaddyHoggy moment.
Oolite Life is now revealed here
User avatar
Selezen
---- E L I T E ----
---- E L I T E ----
Posts: 2530
Joined: Tue Mar 29, 2005 9:14 am
Location: Tionisla
Contact:

Re: Any M$ Excel (Office 2007) gurus out there?

Post by Selezen »

I'm normally pretty good at Excel voodoo, but I would need to take a look at your charts and tables to see what you are doing and try to work out what's going on.

"Need INPUT!"
- Johnny 5
User avatar
DaddyHoggy
Intergalactic Spam Assassin
Intergalactic Spam Assassin
Posts: 8515
Joined: Tue Dec 05, 2006 9:43 pm
Location: Newbury, UK
Contact:

Re: Any M$ Excel (Office 2007) gurus out there?

Post by DaddyHoggy »

I'll put it up on Box and send you the link via PM - thanks Selezen!!!
Selezen wrote:
Apparently I was having a DaddyHoggy moment.
Oolite Life is now revealed here
User avatar
maik
Wiki Wizard
Wiki Wizard
Posts: 2028
Joined: Wed Mar 10, 2010 12:30 pm
Location: Ljubljana, Slovenia (mainly industrial, feudal, TL12)

Re: Any M$ Excel (Office 2007) gurus out there?

Post by maik »

You can send it over here, too. I spend way too much of my work time in Excel...
User avatar
drew
---- E L I T E ----
---- E L I T E ----
Posts: 2190
Joined: Fri May 19, 2006 9:29 am
Location: In front of a laptop writing a book.
Contact:

Re: Any M$ Excel (Office 2007) gurus out there?

Post by drew »

If those kind gents can't solve, I'll give it a whirl too.

Cheers,

Drew.
Drew is an author of SF and Fantasy Novels
WebsiteFacebookTwitter
User avatar
PhantorGorth
---- E L I T E ----
---- E L I T E ----
Posts: 647
Joined: Wed May 20, 2009 6:48 pm
Location: Somewhere off the top left of Galaxy 1 map

Re: Any M$ Excel (Office 2007) gurus out there?

Post by PhantorGorth »

I am willing to wade in if any further help is required. Though I only know Excel up to version 2003 but hopefully the stuff like basic charts hasn't changed much in 2007 compared to 2003 (and I don't mean interface changes)
Chat and relax with other commanders in the [url=irc://irc.oftc.net/oolite]DS's Seedy Space Bar[/url]. The Coolest Bar in the Eight.

Phantor's OXPs: [EliteWiki] GalCop Rewards and [EliteWiki] Safe Docking
User avatar
maaarcooose
---- E L I T E ----
---- E L I T E ----
Posts: 397
Joined: Sun May 29, 2011 9:36 pm
Location: Devon, UK
Contact:

Re: Any M$ Excel (Office 2007) gurus out there?

Post by maaarcooose »

I presume you're using pivot tables and charts?

!m!
Trading computers and writing stuff....
Website: http://www.theramist.co.uk/
OOliteInfo: http://www.theramist.co.uk/ooliteinfo/oo.php
User avatar
Selezen
---- E L I T E ----
---- E L I T E ----
Posts: 2530
Joined: Tue Mar 29, 2005 9:14 am
Location: Tionisla
Contact:

Re: Any M$ Excel (Office 2007) gurus out there?

Post by Selezen »

<waiting for PM>

:-)
User avatar
DaddyHoggy
Intergalactic Spam Assassin
Intergalactic Spam Assassin
Posts: 8515
Joined: Tue Dec 05, 2006 9:43 pm
Location: Newbury, UK
Contact:

Re: Any M$ Excel (Office 2007) gurus out there?

Post by DaddyHoggy »

Waiting for chance to upload data to Box!

<grabs coffee and heads back to lecturer theatre> :roll:
Selezen wrote:
Apparently I was having a DaddyHoggy moment.
Oolite Life is now revealed here
Post Reply