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. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
Line chart, value labeling
|
#6
|
|||
|
|||
Line chart, value labeling
|
#7
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|