Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data for Graphs Steve[_11_] Excel Discussion (Misc queries) 1 January 8th 08 03:30 AM
Graphs - Y Axis Labels Rosie Excel Worksheet Functions 0 October 18th 07 07:14 PM
How can I make graphs if without any data available? Ledi New Users to Excel 1 September 14th 07 02:56 PM
excel graphs data labels in Pivot tables Rosa Campos Charts and Charting in Excel 0 May 9th 06 07:55 PM
Data Analysis and Graphs Rajeev Excel Discussion (Misc queries) 2 May 9th 06 01:08 AM


All times are GMT +1. The time now is 05:53 PM.

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

About Us

"It's about Microsoft Excel"