View Single Post
  #1  
Old September 25th, 2009, 05:57 PM posted to microsoft.public.excel.charting
kuhrty
external usenet poster
 
Posts: 6
Default Pivot Table - Change / Format Legend Names

I created a pivot table graph. I have a ranking field that appear
concatenated like
{color} 1 - Confused
{color} 2 - Ugh

I need to change to
{color} Confused
{color} Ugh

Using this code below, I can format the string but the Name is not
updating

Dim m as Integer
Dim strmk As String
Dim iLen As Integer

For m = 1 To ActiveChart.SeriesCollection.Count
iLen = Len(ActiveChart.SeriesCollection(m).Name)
strmk = (Mid(ActiveChart.SeriesCollection(m).Name, 4,
iLen))
ActiveChart.SeriesCollection(m).Name = "bob"
Next m