Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Problem drawing graphs with EXCEL
Name: Positron Date: January 21, 2004 at 18:25:34 Pacific OS: Xp home CPU/Ram: N/R
Comment:
I am making graphs using MS EXCEL 2002; while plotting a Mathematical function with the smooth lines option I need to ‘High light’ a few points and place a text beside them for example ‘Maximum’ etc. Is this possible in EXCEL at all? How can I do this?
Name: chnos Date: January 21, 2004 at 23:12:18 Pacific
Reply:
add a free text one.Select any point in ur graph and tape ur text.
0
Response Number 2
Name: Positron Date: January 22, 2004 at 03:26:40 Pacific
Reply:
Hi Taxi Thanks for your reply but I still can't get it right. Would you explain it for me?
Regards Positron
0
Response Number 3
Name: chnos Date: January 22, 2004 at 04:41:07 Pacific
Reply:
I mean : anywhere, no matter wher u are on ur graph (just ur drawing zone selected, for example), u type a text and press enter. it creates a mobile text zone in the center of ur graph. Next u make what u want with it..That's all folk!
0
Response Number 4
Name: Positron Date: January 22, 2004 at 20:48:50 Pacific
Reply:
Thank you Taxi I got it right this time, but there is one more thing: can I delete the markers for the points on my graph and just leave a few that I want? It seems when I clear one of them they all disappear.
Positron
0
Response Number 5
Name: chnos Date: January 22, 2004 at 23:10:22 Pacific
Reply:
no.markers it's all or nothin. it can be done: u put all markers, next when u clic on ur markers, first it select all when u clic a second time it selects the one u want (i say its different with a double clic on markers which makes u access to all markers options), it gives u the hand to deconnect it from source : u can remove it, or put the value u want.
0
Response Number 6
Name: Positron Date: January 23, 2004 at 10:54:09 Pacific
Reply:
So I can't have markers only for my especial points, pity, this is a problem with EXCEL! Anyway thank you for your replies & hopefully we will meet each other again.
Cheers
0
Response Number 7
Name: chnos Date: January 24, 2004 at 00:38:47 Pacific
Reply:
Yes u can !insert all and remove those u don't want..!it's just a question with ur double clic to select/remove the one u want. The only thing to do first is put them all and next one/one select individually the one to be formated.I think my explaination was not good...
0
Response Number 8
Name: Positron Date: January 24, 2004 at 19:46:49 Pacific
Reply:
I'm afraid on my EXCEL it doesn't workout that way! For example if I double click on any one and select <NONE> it would delete all of them. So basically I can't format the markers individually! Any Ideas?
0
Response Number 9
Name: chnos Date: January 25, 2004 at 06:33:40 Pacific
Reply:
double clic on one and right clic.Double clic must not be to quick. It works with any excel.U can see ur right when ur marker is surrounded by squares and the cursor comes as a vertical line. So u can enter the value/text u want or remove it. I can't show u of course, but it works.Keep trying !!!
0
Response Number 10
Name: Positron Date: January 28, 2004 at 14:21:08 Pacific
Reply:
YES :) I finally did it!! Thank you very much for your help Taxi. See you around.
0
Response Number 11
Name: chnos Date: January 31, 2004 at 00:11:13 Pacific
Summary: Im trying to create a Line graph ( with markers) using excel. Ive got my data and got everything ruight except i cant seem to get the origin (for the x acis) to be 0. I also cant get the lines to ev...
Summary: Hi there I'm having a problem making a graph with an Excel sheet. It is made up of information based on two types of customers. So in the Type column there is C (for Corporate) and P (for Personal)....
Summary: For no apparent reason I have encountered problems with excel formulas. Instead of dragging formulas across columns, my speadsheets are copying information only. Also, summed columns of figures are no...
0 
