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
Post a Comment