Re Change Chart Series Collection Name in a Pivot Chart Here's what I tried 1) Select a cell in column G of the pivot table 2) PivotTable Tools > Field Settings > Custom Name > Enter a suitable shorter text string (I used "a" and " " to test It will not let me put nothing)If you want to give you data series in Excel a new name or change the values without changing the worksheet's data, here's what to do Open your Excel Sheet/chart that you want to rename Rightclick the chart On the menu displayed, click Select Data To change, edit or rename a Data Series name in Microsoft Excel Graph or Chart without editing the original row or column name, follow this procedure Open the Excel spreadsheet to find the chart
Change A Chart Type Of A Single Data Series Chart Axis Chart Microsoft Office Excel 07 Tutorial