Autoplay Next video from Max length

Excel - Adding a Yearly Total to Chart Table but Not to Chart - Episode 972

1,290 views · Published 17 March 2009 · 2:16 · Indexed 14 November 2026

Channel: MrExcel.com · 2009 · Education

Microsoft Excel Tutorial: Adding a Yearly Total to Chart Table but Not to Chart.

Welcome back to the MrExcel netcast where we tackle all your Excel problems and provide you with the best solutions. I am Bill Jelen and today we have a great question and solution from Virginia Tech. During one of my seminars, a participant asked how to add a year total to a chart data table without making the chart look cluttered. Let's see if we can solve this problem together.

The issue at hand is that when the year total is added to the chart, it makes all the other numbers appear small in comparison. This is where the camera tool comes into play. First, we need to make some room for the data table by resizing the plot area. Then, we will use the camera tool, which can be added to the Quick Access Toolbar or customized in older versions of Excel. Simply select the range that includes the totals, click on the camera tool, and then click inside the chart. This will paste a dynamic picture of the table in the chart.

The best part about using the camera tool is that it creates a live link between the chart and the table. So, if any changes are made to the numbers in the table, it will automatically update in the chart. This not only makes the chart look cleaner, but it also saves time and effort in manually updating the chart. This is a great tip that I learned from the folks at Virginia Tech and I am excited to share it with all of you. Thank you for watching and don't forget to tune in for more helpful tips and tricks on the MrExcel netcast.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

The data table option in a chart can have some annoyances. Today, a question (and a solution) from the Virginia Tech seminar. Episode 972 shows yet another cool use for the camera tool.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Table of Contents:
(00:00) Introduction to the MrExcel netcast
(00:10) A question and solution from Virginia Tech
(00:20) Adding a data table to a chart
(00:33) Adding a year total to the chart
(00:56) Using the camera tool to solve the issue
(01:30) Resizing and updating the table
(01:49) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial

This video answers these common search terms:
Adding new currency symbols in Excel
Applying cell styles in Excel
Applying currency styles in Excel
Changing currency dropdown in Excel
Customizing Quick Access Toolbar in Excel
Excel cell styles
Excel currency symbols
Excel tips and tricks
Learn Excel
Microsoft Excel regional settings
MrExcel Podcast episode 2455
Taming the Currency drop-down in Excel

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1191077/

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152263/

Excel - Adding a Yearly Total to Chart Table but Not to Chart - Episode 972

More from this channel