This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have to keep monthly program stats with a yearly total. Then provide a summary for each year, (2014,2015,2016) in a separate spreadsheet in order to review yearly progress. How do I connect the totals from each monthly/yearly spreadsheet to a year by year comparison. I have formulas throughout the spreadsheet.
Second is there a way to connect the spreadsheet data to graphs?
Thank you
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi,
For better assistance with your concern, we recommend that you post your question over to our TechNet forum instead. TechNet has more members and moderators who are more familiar with the kind of topic you have on your question.
Kindly click on this link to go to TechNet.
Let us know how it goes.