Back in the day, at this stage on the Mac, there was a universality to the data exchange.
The Mac had, among other things, four core data types: text, rich text, bitmap, and PICT.
PICT was an object based drawing (lines, circles, boxes), in contrast to a bitmap.
My memory is vague on Multiplan (I used it at the time, as a spreadsheet). But there was another program called MacChart. Either Multiplan didn't support charting (seems unlikely), or I was simply blind to it.
But, consider this simple workflow: Enter numbers into Multiplan, with all its calculating fun. Copy the column of numbers, hit Cmd-] (I think it was on Switcher), and now you're in MacChart. Paste that column, and you get your instant Pie chart, or Bar chart. Hit Copy again, Cmd-] again to MacDraw, and paste that chart in to MacDraw. Add your lines, labels, whatever you wanted to do to doctor the chart up that MacChart didn't do. All the elements of the chart are editable. The wedges, the rectangles, lines and axis, text etc. Copy again, CMD-], now you're in MacWrite. Paste it in there in the middle of your text. Add the "Figure 1", hit the "Center" button, print it on the LaserWriter, at full resolution (vs a 72 DPI bitmap on a 300 DPI printer). Back then we'd admonish folks that were using space to line up text in MacWrite or MacDraw, as it did not line up properly when printer on the LaserWriter. The ImageWriter was WYSIWYG, but the LaserWriter had more WYGIWIGY (What You Get Is What I Gives You). So, you instead should use ruler tabs and what not, vs the space character.
MacChart took rows of text and charted them. (The calculator desk accessory would sum a column of numbers if you pasted it in to it.) The results of the Multiplan calculations. MacDraw was, essentially, a PICT editor. I don't know if it stored PICTs, but it certainly worked with them as native. And then you stomped them into your MacWrite document.
If you pasted them in to MacPaint, then, boom, it's a bitmap, and you can do all your bitmappy things to it (one way trip, the PICT is lost).
Combined with Switcher (this was pre-Multifinder), at the time, not only was this an extraordinary demo (yea, it was a jaw dropping demo), it was an extraordinary reality. It WORKED!
I spent a lot of time doing this, making slides (printed on transparencies on the LaserWriter). I was on loan to this other group in the company, the manager tried to hire me away because of my l33t Chart and Draw skillz.
I don't know today if I pasted some graphics from Mac Keynote into MS Powerpoint if the it would go over as separate objects or what. I remember trying to paste some graphics from Visio into Powerpoint and it spit up its lunch. It certainly did not Just Work. I was aghast that these two MS products did not seamlessly work together (yes, I know they bought Visio...but, still...).
It's hard to convey how simple this all was. How it all "just worked", with no surprises. On this tiny little beige box with a 9" screen that "nobody considered as a serious computer".
Those few clipboard types where pretty universally respected and it let tools "do one thing well". Switcher let you stitch them together.