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
Any M$ Excel (Office 2007) gurus out there?
Moderators: winston, another_commander, Cody
- DaddyHoggy
- 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?
Oolite Life is now revealed hereSelezen wrote:Apparently I was having a DaddyHoggy moment.
- Selezen
- ---- 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?
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
"Need INPUT!"
- Johnny 5
- DaddyHoggy
- 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?
I'll put it up on Box and send you the link via PM - thanks Selezen!!!
Oolite Life is now revealed hereSelezen wrote:Apparently I was having a DaddyHoggy moment.
- maik
- 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?
You can send it over here, too. I spend way too much of my work time in Excel...
- drew
- ---- 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?
If those kind gents can't solve, I'll give it a whirl too.
Cheers,
Drew.
Cheers,
Drew.
- PhantorGorth
- ---- 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?
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: GalCop Rewards and Safe Docking
Phantor's OXPs: GalCop Rewards and Safe Docking
- maaarcooose
- ---- 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?
I presume you're using pivot tables and charts?
!m!
!m!
Trading computers and writing stuff....
Website: http://www.theramist.co.uk/
OOliteInfo: http://www.theramist.co.uk/ooliteinfo/oo.php
Website: http://www.theramist.co.uk/
OOliteInfo: http://www.theramist.co.uk/ooliteinfo/oo.php
- DaddyHoggy
- 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?
Waiting for chance to upload data to Box!
<grabs coffee and heads back to lecturer theatre>
<grabs coffee and heads back to lecturer theatre>
Oolite Life is now revealed hereSelezen wrote:Apparently I was having a DaddyHoggy moment.