Become a part of the TranceAddict community!Frequently Asked Questions - Please read this if you haven'tSearch the forums
TranceAddict Forums > Main Forums > Chill Out Room > MS Excel Graph (help needed from expert)
  Last Thread   Next Thread
Share
Author
Thread    Post A Reply
Nell
sure thing



Registered: Feb 2001
Location: Newcastle , England
MS Excel Graph (help needed from expert)

I have a set of data:

No Income Unicost Fix costTotal costs
1 £2,340 £1,310 £14,050 £15,360
2 £4,680 £2,621 £14,050 £16,671
3 £7,020 £3,931 £14,050 £17,981
4 £9,360 £5,242 £14,050 £19,292
5 £11,700 £6,552 £14,050 £20,602

which is displayed in a graph inside the spreadsheet.

The graphs shows all the data correctly but I have heard it is possible (and i want to) to be able to show more results if i wanted to (i.e. no 6-50) without having to edit the dataset each time (excel can work it out for me)

anyone know how to do this?


___________________

Old Post May-18-2005 19:37 
Click Here to See the Profile for Nell Click here to Send Nell a Private Message Add Nell to your buddy list Report this Post Reply w/Quote Edit/Delete Message
Dervish
Your opinion matters.



Registered: Dec 2003
Location:

I take it you mean that you have calculations which you want to redo without having to type them in?

If you click and hold onto the bottom corner (of the box) of the last value the calculations will be relative positions.

Hmm hard to explain.

a b c
1
2
3

you can have say c1 = a1 + b1

then pull down like I said and it'll be c2 = a2 + b2 and so on

Old Post May-18-2005 20:23 
Click Here to See the Profile for Dervish Click here to Send Dervish a Private Message Add Dervish to your buddy list Report this Post Reply w/Quote Edit/Delete Message
Nell
sure thing



Registered: Feb 2001
Location: Newcastle , England

i know what you're saying, but it's not what i'm after.

i want the user to enter into a cell one number (1 to infinity) and the graph will then automatically update to display the results:

example:

user types in 30:

graph automatically updates to this:


___________________

Old Post May-18-2005 22:06 
Click Here to See the Profile for Nell Click here to Send Nell a Private Message Add Nell to your buddy list Report this Post Reply w/Quote Edit/Delete Message

TranceAddict Forums > Main Forums > Chill Out Room > MS Excel Graph (help needed from expert)
Post New Thread    Post A Reply

 
Last Thread   Next Thread
Click here to listen to the sample!Pause playbackhelp please, need 8 tunes to ID (some older hard-trance) [2004] [0]

Click here to listen to the sample!Pause playbackNeo Cortex - "Elements" [2004]

Show Printable Version | Subscribe to this Thread
Forum Jump:

All times are GMT. The time now is 13:41.

Forum Rules:
You may not post new threads
You may not post replies
You may not edit your posts
HTML code is ON
vB code is ON
[IMG] code is ON
 
Search this Thread:

 
Contact Us - return to tranceaddict

Powered by: Trance Music & vBulletin Forums
Copyright ©2000-2026, Jelsoft Enterprises Ltd.
Privacy Statement / DMCA
Support TA!