Pie Charts how do you show Label and Value?

[Koggala]

I usually get an answer really quickly, i have searched but no luck.

Can you show the label and Value on a pie chart?

If so, how?

Thanks eveyone.....

 

[earlyd]

right-click on the pie and choose format data series...check out the the data labels tab

 

[Koggala]

Tried that, but no Label and value option is there !

Maybe it can't be done?

 

[earlyd]

I just did it. Check the box that says Value and/or the box that says percentage

 

[Koggala]

Thanks for your help but i do not want the percentage, i want "label and Value"

Any ideas?

 

[Brian from Maui]

Thanks for your help but i do not want the percentage, i want "label and Value"

Any ideas?

Format Data series, select Data Labels, tick Category Name and Value

 

[J R Daniels]

Does the option for Label and Value only appear in later versions of Excel? It is not present in Excel 97.

There is a macro workaround which seems to work OK but looks rather OTT at http://support.microsoft.com/default.aspx?scid=kb;en-us;213750

This is supposedly for an XY scatter chart but works OK for a pie chart in '97. I am sure it can be trimmed down for a single series pie chart but haven't figured out how yet.

Regards

John Daniels

 

[GlennUK]

Can you have a different cell for your label?

Can you have your labels in separate cells?

For example, have a cell per series point containing something like:

=A2&CHAR(10)&B2

where A2 has the point label, and B2 has the point value.

Then you have a simple macro to attach each new label to each point in the series. Like this:

Sub addlabels()

    ActiveSheet.ChartObjects("Chart 3").Activate
    mycellpointer = 2
    For Each p In ActiveChart.SeriesCollection(1).Points
        p.ApplyDataLabels Type:= _
            xlDataLabelsShowLabel
        p.DataLabel.Select
        Selection.Text = "=Sheet1!R" & mycellpointer & "C6"
        mycellpointer = mycellpointer + 1
    Next
    
End Sub

I had my new labels in column F ( C6 in Text formula ). Hope this is of some use.

 

[J R Daniels]

I had sussed this out since posting, but thanks for the advice. The beauty of concatenating strings to give the label + value and using that as the labels reference is that the graph and its labels and values stay 'live' so if a value is changed the graph is automatically updated correctly. Using a macro to add the values after the graph is drawn does not stay live - the graph may get re-drawn to the correct proportions but the label won't change unless the macro is re-run.

It does seem from some of the above replies that some versions of Excel allow you to select label and value - will try to find out later (can test up to 2002 but not 2003).

Regards

John Daniels

 

[GlennUK]

Yes, that's the trick to remember .... to link to cell references to make the label "live". That's why I posted that example, I knew it might be useful if you hadn't worked it out yet.