Hi,
To turn off the tooltips select the chart and use,
Office button Excel Options Advanced Display Show data point values
on hover.
You can create the brackets using a couple of approaches.
First use a helper column to build the text for your data. So if your x and
y values are in A2 and B2 then in C2 use
="(" & A2 & "," & B2 & ")"
You can then use this free addin to link data labels to cells.
http://www.appspro.com/Utilities/ChartLabeler.htm
Another way is to use custom number format.
For your X values use
(General
For you Y values use
General)
You can now use data labels displaying both x and y value separated by
comma. You will need to format both the x and y axes to have General number
format in order to remove the brackets from the axis labels.
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Neil Goldwasser" wrote in
message ...
Hi all!
Using Excel 2007, I have made a chart using a data series with the
x-values
in one column and the y-values in another. I wish to show the data label
for
these points, but want to include the brackets to replicate the
mathematical
way of expressing the co-ordinate i.e. that the data label would read (-8,
6)
instead of -8, 6. I've tried creating a custom data label using format
codes,
but I'm getting nowhere fast. Can anyone help please?
Also, I have a second series on the same graph that I do NOT want to
display
this information (I'm making a teaching resource). It does not have a data
label, but if you hover the mouse over it, it does display the coordinate.
Can I turn this off?
Many thanks in advance, Neil