Using 3-D Formulas for Pie Charts (MAC)

Creating an annual department budget. I want to see how much three different programs spend on marketing/advertising. My document has three worksheets—one for each program. I'm hoping to use a 3-D formula to create a pie chart that breaks down how much of the advertising budget is spent by each department. Ideally I'd like the pie chart on a separate worksheet (labeled TOTALS). I've tried a few different ways and am having trouble getting a 3D formula to work for the pie chart. Any insight would be terrific.

Running MacOS Mojave 10.14.6. Thanks!