Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 457
  • Last Modified:

Excel Pivot Chart

Hi Experts,

I have a Pivot table and a chart that are build on that pivot. The problem is that i rename the value legend in the PivotTable Field List, but it still writes "Total" as Legend name. If i then add one more data series then it changes the legend to the title i have chosen. So why is it the Excel feels that it should decide the title of the legend when i one have one data series instead of multiple?
0
DCRAPACCESS
Asked:
DCRAPACCESS
  • 6
  • 2
  • 2
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

Not sure I can follow. Can you post a sample file that displays the behaviour you describe? Please use only dummy data, not your real business data.

cheers, teylyn
0
 
DCRAPACCESSAuthor Commented:
With_one_Data_series
With_2_data_series
I hope this helps?
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Screenshots are great to show what you see on your screen. To see what makes the chart act like it does, the real Excel workbook is required. Charts have many dependencies on the way the source data is laid out and defined.

Can you post the workbook you used to create the screenshots?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
DCRAPACCESSAuthor Commented:
Here is a sample
SAMPLE.xlsb
0
 
DCRAPACCESSAuthor Commented:
Now with this test, drag the field "inden for Servicemål" down to the Values field, then you will see that the Total Legend will change to "THIS IS A TEST".
0
 
DCRAPACCESSAuthor Commented:
But the issue is that it says "TOTAL" when it should say "THIS IS A TEST"
0
 
Rory ArchibaldCommented:
As far as I am aware, there is no way to change that - you need to either use the chart title instead or perhaps add a textbox.
0
 
DCRAPACCESSAuthor Commented:
I know that a text box would solve it, if the backgroud is soild  and white. But I still think that it is stupid that you can't change it. (In my world that is a bug)
0
 
Rory ArchibaldCommented:
I agree. Not much I can do about it though.
0
 
DCRAPACCESSAuthor Commented:
Not what I was hoping for, but is ok
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 6
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now