Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data Labels on XY graphs
I began using Office with Office 95, about 12 years ago. Before that, I used
Lotus and Quattro Pro. With those softwares, I had no problem to graph column A and B as X and Y axis, and use a third column C as a source for data labels. With the various new Excel versions since Excel 95, I always look for such a possibility, without ever finding it. I don't see it in Excel 2007 either. All I can do in Excel is limited to use the content of column A or B as data label, but there is no possibility to use a third column as data label. To display other data labels than the values of X or Y (which is not really useful as I can read the values on the axis), I have to use VBA. Is Microsoft considering some day to allow a third column for data labels ? Thanks in advance for any answer. -- Phil ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...excel.charting |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data Labels on XY graphs
We've been waiting. In the meantime, there are a couple of free Excel
utilities you could try. Rob Bovey's Chart Labeler, http://appspro.com/Utilities/ChartLabeler.htm John Walkenbach's Chart Tools, http://www.j-walk.com/ss/excel/files/charttools.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Philippe" wrote in message ... I began using Office with Office 95, about 12 years ago. Before that, I used Lotus and Quattro Pro. With those softwares, I had no problem to graph column A and B as X and Y axis, and use a third column C as a source for data labels. With the various new Excel versions since Excel 95, I always look for such a possibility, without ever finding it. I don't see it in Excel 2007 either. All I can do in Excel is limited to use the content of column A or B as data label, but there is no possibility to use a third column as data label. To display other data labels than the values of X or Y (which is not really useful as I can read the values on the axis), I have to use VBA. Is Microsoft considering some day to allow a third column for data labels ? Thanks in advance for any answer. -- Phil ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...excel.charting |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data Labels on XY graphs
Hi Jon,
Thaks a lot for your answer. In fact, I browsed the related messages, and I'd already downloaded ChartLabeler. It works, even if my first try provoked an Excel 2000 crash. Still strange that a possibility which existed in Lotus 20 years ago and was so useful is still not included in Excel 2007. Looking at the forum, I see that many miss this possibility. -- Phil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data for Graphs | Excel Discussion (Misc queries) | |||
Graphs - Y Axis Labels | Excel Worksheet Functions | |||
How can I make graphs if without any data available? | New Users to Excel | |||
excel graphs data labels in Pivot tables | Charts and Charting in Excel | |||
Data Analysis and Graphs | Excel Discussion (Misc queries) |