View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Graphical co-ordinates format data label (with brackets) for chart

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