A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Line chart, value labeling



 
 
Thread Tools Display Modes
  #1  
Old April 15th, 2004, 09:32 PM
Andy Pope
external usenet poster
 
Posts: n/a
Default Line chart, value labeling

Hi,

You need to select the line series and then select a single point before
displaying the format dialog and enabling data labels.

Cheers
Andy

NYBoy wrote:

I like to change line graph settings so that only one value will appear
on the line (not all the values).
I right clicked on the point on the line, selected format data series,
selected Data Labels tab, checked box Show Values. and then click ok.
All the data values show up on the line. But, I like to see only one
specific value. How do we do that?


---
Message posted from http://www.ExcelForum.com/


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #2  
Old April 15th, 2004, 09:49 PM
NYBoy
external usenet poster
 
Posts: n/a
Default Line chart, value labeling

Thanks Andy, It works!!

One more question.
It would be the last point. Every month I update the data and the line
extends and new data is entered. I always want to see the value of last
point. Would it work?


---
Message posted from http://www.ExcelForum.com/

  #3  
Old April 15th, 2004, 10:02 PM
Andy Pope
external usenet poster
 
Posts: n/a
Default Line chart, value labeling

Jon Peltier's has a page on the very subject!

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

NYBoy wrote:

Thanks Andy, It works!!

One more question.
It would be the last point. Every month I update the data and the line
extends and new data is entered. I always want to see the value of last
point. Would it work?


---
Message posted from http://www.ExcelForum.com/


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #4  
Old April 15th, 2004, 11:03 PM
NYBoy
external usenet poster
 
Posts: n/a
Default Line chart, value labeling

Thanks Andy,
I am not familiar with Excel VBA project stuff. I don't know where to
paste once I copied the commands.
I think I am gonna have ask my boss to do it.


---
Message posted from http://www.ExcelForum.com/

  #5  
Old April 15th, 2004, 11:43 PM
NYBoy
external usenet poster
 
Posts: n/a
Default Line chart, value labeling

How do we close the thread?


---
Message posted from http://www.ExcelForum.com/

  #6  
Old April 15th, 2004, 11:44 PM
NYBoy
external usenet poster
 
Posts: n/a
Default Line chart, value labeling

How do we close the thread?


---
Message posted from http://www.ExcelForum.com/

  #7  
Old April 16th, 2004, 12:07 AM
Andy Pope
external usenet poster
 
Posts: n/a
Default Line chart, value labeling

If you have the workbook with the chart open use ALT+F11 to get to the
VBE (Visual Basic Editor/Environment).
Use the Insert menu to add a Module.
Paste the code from Jon's page.

ALT+F11 to return to your workbook.
select the chart and the press ALT+F8 to display the Macro dialog.
From here run the LastPointLabel Macro.

To 'close' the thread just post a reply to say the solution worked.

Cheers
Andy

NYBoy wrote:

Thanks Andy,
I am not familiar with Excel VBA project stuff. I don't know where to
paste once I copied the commands.
I think I am gonna have ask my boss to do it.


---
Message posted from http://www.ExcelForum.com/


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #8  
Old April 16th, 2004, 12:26 AM
NYBoy
external usenet poster
 
Posts: n/a
Default Line chart, value labeling

Thanks Andy, It somewhat worked.
But it gave me the Title (of the line from that row) instead of the
mathematical value of the last point.


---
Message posted from http://www.ExcelForum.com/

  #9  
Old April 16th, 2004, 12:42 AM
NYBoy
external usenet poster
 
Posts: n/a
Default Line chart, value labeling

This is the first time I am visiting the Exceltip.com....it's pretty
cool..

Andy, I went to your website and downloaded your clocks. When I click
Start, a msg pop up saying "macros are disabled....". Is it just me or
my computer??


---
Message posted from http://www.ExcelForum.com/

  #10  
Old April 16th, 2004, 05:02 AM
Jon Peltier
external usenet poster
 
Posts: n/a
Default Line chart, value labeling

NY -

By default, the security settings in Excel are high. If you set them to
medium, you at least have an option to enable macros in each workbook
you open. On the Tools menu, select Macros, then Security, and on the
Security Level tab, select Medium.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/
_______

NYBoy wrote:
This is the first time I am visiting the Exceltip.com....it's pretty
cool..

Andy, I went to your website and downloaded your clocks. When I click
Start, a msg pop up saying "macros are disabled....". Is it just me or
my computer??


---
Message posted from http://www.ExcelForum.com/


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:54 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.