Hosted by 2WDH.com .:. Professional and affordable web hosting...
 Home | Forums | Donate
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

top ten songs
Goto page Previous  1, 2, 3, 4, 5, 6, 7, 8, 9  Next
 
Post new topic   Reply to topic    Twisted Mind Games Forums Forum Index -> Random Discussion
View previous topic :: View next topic  
Author Message
Das Mole
Emo


Joined: 21 May 2003
Posts: 1018
Location: Chicago
PostPosted: Sat Jul 03, 2004 10:09 pm    Post subject: Reply with quote
okay. now i've got a problem. does anyone know how to change a chart on excel so that it covers a larger cell area? for example, let's say your chart covers from cells a1 to d4. but you add to more columns. how do you get your chart to go from a1 to d6 instead, without making a completely new one? i tried using the helpwizard thing, but nothing shows up.
_________________
puzzle designer. moderator.
Back to top
View user's profile Send private message AIM Address MSN Messenger
James
3run
3run


Joined: 19 May 2003
Posts: 3756
PostPosted: Sun Jul 04, 2004 6:24 am    Post subject: Reply with quote
I am using Excel 2002, so this might be slightly different:

-Go back to step 2 of 4 on the wizard (data range), and in the drop down list it should say something like:

Code:
=Sheet1!$A$1:$B$3


change this to whatever you want. $B$3 is the bottom right cell to take data from, so if i wanted to take one more coumn, i would change it to:

Code:
=Sheet1!$A$1:$C$3


Hope that worked Wink
_________________
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Das Mole
Emo


Joined: 21 May 2003
Posts: 1018
Location: Chicago
PostPosted: Sun Jul 04, 2004 9:40 pm    Post subject: Reply with quote
except, how do you get back to the steps in the chartwizard for that chart?
_________________
puzzle designer. moderator.
Back to top
View user's profile Send private message AIM Address MSN Messenger
James
3run
3run


Joined: 19 May 2003
Posts: 3756
PostPosted: Mon Jul 05, 2004 6:06 am    Post subject: Reply with quote
Right Click >> Source data.

Then do the steps i said to change where the graph looks.
_________________
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Das Mole
Emo


Joined: 21 May 2003
Posts: 1018
Location: Chicago
PostPosted: Mon Jul 05, 2004 2:31 pm    Post subject: Reply with quote
my version doesn't do that...where do you click on the chart? do you click the chart itself, or the white part? b/c i can do that, but only w/the individual lines, so then there's no way to add the new songs. and to be quite honest, i don't want to have to go through the whole color changes and line length and shapes crap all over again.
_________________
puzzle designer. moderator.
Back to top
View user's profile Send private message AIM Address MSN Messenger
James
3run
3run


Joined: 19 May 2003
Posts: 3756
PostPosted: Mon Jul 05, 2004 3:39 pm    Post subject: Reply with quote
For me you have to right click on the white area of the graph... but it might be different in Excel 2002.
_________________
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Das Mole
Emo


Joined: 21 May 2003
Posts: 1018
Location: Chicago
PostPosted: Mon Jul 05, 2004 4:09 pm    Post subject: Reply with quote
oh. that sucks. well, in that case i won't update the chart. maybe in like, 5 weeks when it's gonna be at least some more new songs and stuff...i'm not going through all that work every week.
_________________
puzzle designer. moderator.
Back to top
View user's profile Send private message AIM Address MSN Messenger
James
3run
3run


Joined: 19 May 2003
Posts: 3756
PostPosted: Mon Jul 05, 2004 8:02 pm    Post subject: Reply with quote
if you sent me the excel document i might be able to do it for you...
_________________
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Das Mole
Emo


Joined: 21 May 2003
Posts: 1018
Location: Chicago
PostPosted: Tue Jul 06, 2004 3:32 pm    Post subject: Reply with quote
okay. i sent it.
_________________
puzzle designer. moderator.
Back to top
View user's profile Send private message AIM Address MSN Messenger
James
3run
3run


Joined: 19 May 2003
Posts: 3756
PostPosted: Tue Jul 06, 2004 3:50 pm    Post subject: Reply with quote
sent the fixed version. hope it works Smile
_________________
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Das Mole
Emo


Joined: 21 May 2003
Posts: 1018
Location: Chicago
PostPosted: Wed Jul 07, 2004 1:26 pm    Post subject: Reply with quote
i didn't get it...Confused
_________________
puzzle designer. moderator.
Back to top
View user's profile Send private message AIM Address MSN Messenger
ray jones
Level 2: The Rescue
Level 2: The Rescue


Joined: 07 Jul 2004
Posts: 7
Location: digital
PostPosted: Wed Jul 07, 2004 3:15 pm    Post subject: Reply with quote
confused, eh?
_________________
__________________
Back to top
View user's profile Send private message
James
3run
3run


Joined: 19 May 2003
Posts: 3756
PostPosted: Wed Jul 07, 2004 5:50 pm    Post subject: Reply with quote
Indeed ( Confused )

Sent it again. Must have been an error when i sent it
_________________
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Das Mole
Emo


Joined: 21 May 2003
Posts: 1018
Location: Chicago
PostPosted: Wed Jul 07, 2004 7:24 pm    Post subject: Reply with quote
ray wrote:
confused, eh?


as always ¬
_________________
puzzle designer. moderator.
Back to top
View user's profile Send private message AIM Address MSN Messenger
Das Mole
Emo


Joined: 21 May 2003
Posts: 1018
Location: Chicago
PostPosted: Wed Jul 07, 2004 7:42 pm    Post subject: Reply with quote
alrighty. here's the chart, nice and updated:


_________________
puzzle designer. moderator.
Back to top
View user's profile Send private message AIM Address MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic    Twisted Mind Games Forums Forum Index -> Random Discussion All times are GMT
Goto page Previous  1, 2, 3, 4, 5, 6, 7, 8, 9  Next
Page 4 of 9

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group
All of the content on this site is property of its respective owner. No content may be used for other purposes without permission. Content from the site can be shown elsewhere, as long as it isn't tampered with, and a link back to the site is given. This site was designed and coded by James Isaac. Site and contents © 2004-2005.