Change chart data range - resizing handles missing - Microsoft Community


hi,

in previous versions of excel change data range chart going select data source , dragging resizing handle on relevant cells. in version 15.38 don't seem able there no handles drag cells!

can help?

thank you.

i'm not chart guru, don't know of way suppress individual components of chart unless there sort of vba method.

one thing can do, though, hide rows/columns in data range. chart update display visible data. if need on regular basis, can create custom view each of different manners want plot, switch 1 custom view rather having go through hide/unhide process each time... if do, make sure create custom view complete display 1 each hidden combination.



Office / Excel / Mac / Office 2016 for Mac



Comments

Popular posts from this blog

Getting ErrorCode: 120018 when trying to access Microsoft account - Microsoft Community

The message was sent to a distribution list ‎(DL)‎ - Microsoft Community

Activation Error 0x8004FE93 - Microsoft Community