Previous in Forum: Lift Airconditioning   Next in Forum: Stationary Gantry Crane: I-Beam Help Needed
Close
Close
Close
10 comments
Guru

Join Date: Aug 2007
Location: Columbia City, Indiana, USA
Posts: 832
Good Answers: 96

Any MS Excel Gurus Out There?

11/12/2008 12:29 AM

Hi friends and associates,

I'm trying to find if in Excel, I can position text in a graph relative to a particular position.

Specifically, if I have a data point, I want text there to define that point (ex: X and Y), and as that point changes, have the text also re-position near that point.

I've done some knowledge base searching, but so far haven't found a way.

Any help would be appreciated.

Thanks in advance, and kind regards ...

__________________
"Just when I had all the answers, they changed all the questions"
Register to Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

Comments rated to be Good Answers:

These comments received enough positive ratings to make them "good answers".

Comments rated to be "almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, rate them!
Guru
Brazil - Member - New Member Engineering Fields - Mechanical Engineering - New Member Hobbies - RC Aircraft - New Member Hobbies - Target Shooting - New Member Hobbies - Automotive Performance - Hey there... interested in exchanging information about car performance? Hobbies - DIY Welding - New Member

Join Date: Jan 2007
Location: Porto Alegre - RS - Brazil 30deg01'39.73"S 51deg13'43.45"W
Posts: 831
Good Answers: 28
#1

Re: Any MS Excel Gurus Out There

11/12/2008 6:05 AM

The only thing similar to this I've heard in excell is the point tag, with the standard option in the graph to display the series name, and the value coordinates (I'm assuming a XY dispersion type...). The text follows the points.

__________________
Humm... suspicious you are...
Register to Reply
6
Guru
Canada - Member - Our strength is our diversity

Join Date: Jan 2007
Location: Canada
Posts: 1024
Good Answers: 40
#2

Re: Any MS Excel Gurus Out There

11/12/2008 11:31 AM

What you are looking for is "Data Labels"

Before you make a graph under "Tools" select "Options". Select "Chart",and "show values" OK

or

After the chart is created; select the chart/graph, then Select "chart", "Chart options", Select "Data labels" and "Show Value" OK

Once the values are on the chart, click off the chart. Then Right click on a value and select "Format Data Labels" Select the Label position i.e above.

It is also possible to drag the individual labels to the location you want.

__________________
Perfection is a subjective and abstract concept.
Register to Reply Good Answer (Score 6)
Guru

Join Date: Aug 2007
Location: Columbia City, Indiana, USA
Posts: 832
Good Answers: 96
#3
In reply to #2

Re: Any MS Excel Gurus Out There

11/12/2008 7:27 PM

Awesome ... wonderful ... terrific ... great

Thanks very much.

Kind regards ...

__________________
"Just when I had all the answers, they changed all the questions"
Register to Reply
Guru
United Kingdom - Member - Not a new member!

Join Date: Jun 2008
Location: USA/Europe
Posts: 4547
Good Answers: 68
#4
In reply to #2

Re: Any MS Excel Gurus Out There

11/12/2008 10:48 PM

Hello techno:

A worthy GA earned for that!

Take care......

__________________
Take it easy, bb. >"HEAR & you FORGET<>SEE & you REMEMBER<>DO & you UNDERSTAND"<=$=|O|=$=>"Common Sense is Genius dressed in its Working Clothes"<>[Ralph Waldo Emerson]
Register to Reply
2
Power-User

Join Date: Jan 2007
Location: Johannesburg, South Africa
Posts: 170
Good Answers: 12
#7
In reply to #2

Re: Any MS Excel Gurus Out There

11/14/2008 1:40 AM

If you want labels that are not the values, you can install an add-on that does it for you. For example, if you keep track of fuel consumption, and you chart the mpg or km/l or whatever as you go along, with you odo reading as the X-axis values, you would typically have in column A the mileage, column B the fuel consumption, & you might want some descrtiption in column C to explain deviations from the norm, such as "Towing heavy load" or "High speed cross-country" or "Sand: 4x4 low range". It is sometimes nice to show this as a label on the graph as well. Quattro Pro used to do it as standard, but not Excel.

Download Rob Bovey's free XY Chart Labeler from http://www.appspro.com/Utilities/ChartLabeler.htm - it's a lifesaver sometimes, I've used it for years.

Register to Reply Good Answer (Score 2)
Guru
United Kingdom - Member - Not a new member!

Join Date: Jun 2008
Location: USA/Europe
Posts: 4547
Good Answers: 68
#8
In reply to #7

Re: Any MS Excel Gurus Out There

11/14/2008 1:14 PM

Hello gideon:

Good advice there. I am trying to get my head round Excel myself and, all the advice here is helping, thank you. GA to you

__________________
Take it easy, bb. >"HEAR & you FORGET<>SEE & you REMEMBER<>DO & you UNDERSTAND"<=$=|O|=$=>"Common Sense is Genius dressed in its Working Clothes"<>[Ralph Waldo Emerson]
Register to Reply
Guru

Join Date: Aug 2007
Location: Columbia City, Indiana, USA
Posts: 832
Good Answers: 96
#10
In reply to #7

Re: Any MS Excel Gurus Out There

11/15/2008 3:10 AM

Thanks, Gideon ... a great lead and good suggestion.

Kind regards ...

__________________
"Just when I had all the answers, they changed all the questions"
Register to Reply
Power-User
Engineering Fields - Mechanical Engineering - Member Engineering Fields - Piping Design Engineering - Member United Kingdom - Member - New Member Technical Fields - Education - New Member Popular Science - Cosmology - New Member

Join Date: Sep 2006
Location: England
Posts: 101
Good Answers: 3
#5

Re: Any MS Excel Gurus Out There?

11/13/2008 4:33 AM

Hi DCaD,

I sometimes find these two websites helpful:

http://peltiertech.com/Excel/Charts/

http://www.excelcalcs.com/

Kind Regards

Kev Brown

Register to Reply Score 1 for Good Answer
Guru
United Kingdom - Member - Not a new member!

Join Date: Jun 2008
Location: USA/Europe
Posts: 4547
Good Answers: 68
#9
In reply to #5

Re: Any MS Excel Gurus Out There?

11/14/2008 1:21 PM

Hello Kev_brown:

Your listed sites all add to the help people like myself need as we try to unravel the intricacies of excel.

If you use it everyday and know what to do, fine.

But I use it pretty infrequently, and find it difficult to crack as I return

Take care, GA on its way.

__________________
Take it easy, bb. >"HEAR & you FORGET<>SEE & you REMEMBER<>DO & you UNDERSTAND"<=$=|O|=$=>"Common Sense is Genius dressed in its Working Clothes"<>[Ralph Waldo Emerson]
Register to Reply
Power-User
Hobbies - Fishing - New Member

Join Date: Feb 2007
Location: Suva Fiji Islands
Posts: 229
Good Answers: 3
#6

Re: Any MS Excel Gurus Out There?

11/13/2008 8:54 PM

Hi DCaD Techno answered the question for you. In addition to this you can use the Draw Toolbar to add text boxes arrows highlights etc to your charts.

__________________
"Multa ferunt anni venientes commoda secum, Multa recedente adimiunt". (The years as they come bring many agreeable things with them; As they go they take many away).
Register to Reply
Register to Reply 10 comments
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

Comments rated to be Good Answers:

These comments received enough positive ratings to make them "good answers".

Comments rated to be "almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, rate them!
Copy to Clipboard

Users who posted comments:

babybear (3); bhrescobar (1); coconutpete (1); DCaD (2); gideon (1); Kev_brown (1); techno (1)

Previous in Forum: Lift Airconditioning   Next in Forum: Stationary Gantry Crane: I-Beam Help Needed

Advertisement