Pivot Chart Select Data Source Buttons Greyed Out

I've created a new workbook and in it I created a new pivot table and chart.  When I right-mouse-click on the chart and choose Select Data then the Select Data Source dialog box opens.  However, only the Switch Row/Column button is active.  Under the Legend Entries section (on the left) the Add, Edit, Remove, Move Up, and Move Down buttons are all greyed out.  Under the Horizontal Axis Labels section (on the right) the Edit button is greyed out.

I'm using Office 2013 from my current Office subscription.  The workbook and worksheets were left at their defaults.  Protection was not turned on.  How do I enable editing within the Select Data Source dialog box?

Thanks in advance,

Andrew


Answer
Answer

there is a good tutorial with step by step instructions for this scenario on Jon Peltier's site here: http://peltiertech.com/WordPress/dynamic-chart-using-pivot-table-and-range-names/

Let me know if you have any questions after following the advice on that page.

___________________
cheers, teylyn
 
Community Moderator
www.teylyn.com

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated November 28, 2020 Views 31,863 Applies to: