Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot chart series label
Hello -
I have a Pivot Chart where I am using the Data as the axis labels (example: several jobs where the data sums up the number of people in that category - 3 salesman, 2 managers, etc.) The issue is that the label showing in my chart says "Sum of Manager". Is there a way to get it to say only Manager? Thx! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot chart series label
You can't use a label that's exactly the same as the field name, but
this workaround works well: Right-click on the Sum of Manager button in the chart Click on Format PivotChart Field In the Name box, delete the existing text and type Manager, followed by a space character. Now the name will be Manager <space Click OK The space character makes the name slightly different than the field name, so Excel will allow it as a label caption. JDRamsey1 wrote: Hello - I have a Pivot Chart where I am using the Data as the axis labels (example: several jobs where the data sums up the number of people in that category - 3 salesman, 2 managers, etc.) The issue is that the label showing in my chart says "Sum of Manager". Is there a way to get it to say only Manager? Thx! -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove series from pivot chart | Charts and Charting in Excel | |||
Dynamic chart - series label problem | Charts and Charting in Excel | |||
Multiple chart series for Pivot Chart | Charts and Charting in Excel | |||
Data series label in Stacked Chart | Charts and Charting in Excel | |||
Pivot Chart Data Label Format Question | Excel Discussion (Misc queries) |