Hi,

I have a couple of doubts in charts:

1) I have a graph where the Column and line charts are plotted on the
same axis. I have got that correctly as well. Now, the problem is I
want to display selective "Data Labels" on the *line graph*. How do I
accomplish this task? (Actually the values for my line graph are same,
hence its just a stright line. And I donot want the same value to be
displayed again and again. I need just one data label on the beginning
of the line)

2) Problem with Doughnut Chart: I have my "Category labels" on multiple
rows (each value is typed in 3 rows). As a result, the graph wizard
takes that as 3 different values. I tried merging the cells but in that
case I lose the contents of cell when they are merged as the value from
the first merged cell is taken. Is there a way out of this?

3) Pie Chart: I have a pie chart representing the "Points" scored by
different players. (i.e. on the excel sheet I have 2 columns: one for
player name and the other for Points). The players are from different
countries. Now, here is the problem: Instead of the legends showing the
player name I want the legends to show the Country Name to which these
players belong to. E.g. I have 8 records in total: 3 players are from
Australia, 4 are from US and 1 from India. Now in the legends I want
these 3 country names.

Pleaseeee do reply


--
pmtw
------------------------------------------------------------------------
pmtw's Profile: http://www.excelforum.com/member.php...o&userid=33137
View this thread: http://www.excelforum.com/showthread...hreadid=529464