Hi,

So this is more PowerPoint related, but its the best resource i know of!

I have a Column Chart in a PowerPoint slide and right next to it in the same slide, an Excel Table. The chart shows Month 1 total on the left column, and month 2 column on the right. The Excel table shows the same data, but the totals are broken down by employee.

There has to be a way for me to have the Chart Data Selection be from that Excel table right? Right now I have to use "Chart in Excel," where I have to add up employee totals anyway, so I'm entering data twice! I hate that!

I have tried linking the Excel Table in PowerPoint to the Excel Spreadsheet that the chart is linked to, but I have multiple charts, and so when I open a second Excel Spreadsheet, the name changes to "Chart 2 in Microsoft...". I can easily figure this out, but I am unfortunately sending this out as a template, and the users absolutely will not understand how to use it. This is why I'm going for the simplicity of entering the data and having it update all right within the PowerPoint slide.

thanks in advance!