Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 03-17-2023, 10:32 AM
kilroyscarnival kilroyscarnival is offline Y Values in Chart Do Not Update When a Row Is Added to the Table Windows 10 Y Values in Chart Do Not Update When a Row Is Added to the Table Office 2021
Expert
 
Join Date: May 2019
Posts: 361
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by skeezix View Post
Thank you for replying and for the images.

I don't understand what a "proper" table is. Maybe it's something other than what Excel 2000 provides...?
Might be. I can't remember that far back. But in ribbon Excel-world, formatting your data range as a table does a bunch of things that make adding data, filtering, and doing formulas that you can repeat down the column easier.

Ten Reasons to use Tables in Excel | Chris Menard Training gives a pretty good look at what tables can do. The main thing I thought of with what you are doing is that the table will automatically see when you're adding a new row beneath the existing ones, and format them as part of the table. So if a chart were created off that column rather than cells (A2:A5), it would include any new data as you built it up.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Table with values from several locations and years - need to find comp values Ricardo Sousa Excel 9 07-27-2018 02:06 AM
Can we update Chart in PPT based on a table in the excel and the table is part of the Chart Data nareshj PowerPoint 0 07-12-2018 02:29 PM
Y Values in Chart Do Not Update When a Row Is Added to the Table Table with values from several locations and years - need to find comp values Ricardo Sousa Excel 6 06-09-2018 10:51 PM
Y Values in Chart Do Not Update When a Row Is Added to the Table How can I make a table or chart to interpolate between values? lbeck Excel 7 10-03-2016 12:37 AM
Update a summary chart when I update a dashboard with dates cangelis Excel 6 09-24-2014 08:08 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:45 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft