Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-11-2023, 05:37 PM
skeezix skeezix 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 97-2003
Competent Performer
Y Values in Chart Do Not Update When a Row Is Added to the Table
 
Join Date: Jan 2019
Posts: 100
skeezix is on a distinguished road
Default Y Values in Chart Do Not Update When a Row Is Added to the Table

Suddenly my chart fails to update. When I add a row to the bottom of the table, the lines in the chart do not reflect that addition. I've tried a lot of things but I can't get the added row(s) to show up in the chart. I've compared the chart to other charts that do not have the problem and I can't find any differences.

In the chart, the X values are dates and the Y values are blood pressure readings.

I've been updating this chart twice a month since 2006 and I don't know why the lines in the chart have stopped reflecting values in the added row in the table. I have many other charts in other Excel files that do not have this problem. It's only a problem either with this one specific chart or with this one specific Excel file. Can somebody please help me out here?

Thanks,
Skeezix
__________________
* HP Pavilion Desktop 510-p114
* Windows 10 Home 22H2 19045.4123; Office 2000

Last edited by skeezix; 03-11-2023 at 06:12 PM. Reason: More info
Reply With Quote
  #2  
Old 03-12-2023, 06:02 PM
skeezix skeezix 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 97-2003
Competent Performer
Y Values in Chart Do Not Update When a Row Is Added to the Table
 
Join Date: Jan 2019
Posts: 100
skeezix is on a distinguished road
Default

The attached Excel file demonstrates the problem.
Attached Files
File Type: xls ARM Oct 2022 - May 2023.xls (39.0 KB, 4 views)
__________________
* HP Pavilion Desktop 510-p114
* Windows 10 Home 22H2 19045.4123; Office 2000
Reply With Quote
  #3  
Old 03-17-2023, 07:23 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: 344
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
The attached Excel file demonstrates the problem.
Hi, Skeezix,

Two things: First, I suggest you make your data a proper table, so that you'll be sure that it picks up subsequent rows as you add them at the bottom.

Second, the reason you might not see individual dates on your chart is because the X Axis is set as a "Date Axis." When I opened it it shows the units both major and minor are 15 days.

I noticed you're working with Excel 97-2003 (.xls) files, so maybe you have an older version and controls might not look exactly the same. But, when you work with a date axis, generally it's designed to plot data along an incremental time line (in your case, 15 days). By changing it to a text axis and changing the controls, I was able to see a plot of every single entry you made, plus I made a few more by copying previous lines to a new date at the bottom.

Incidentally, you'll see the line for Pulse didn't extend - because the way you'd selected your data for Pulse, it didn't expand to accommodate new rows. That's why starting with your data as a table can be beneficial.
Attached Images
File Type: jpg date axis.jpg (195.5 KB, 17 views)
File Type: jpg text axis.jpg (244.1 KB, 17 views)
Attached Files
File Type: xls ARM Oct 2022 - May 2023.xls (42.5 KB, 1 views)
Reply With Quote
  #4  
Old 03-17-2023, 10:00 AM
skeezix skeezix 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 97-2003
Competent Performer
Y Values in Chart Do Not Update When a Row Is Added to the Table
 
Join Date: Jan 2019
Posts: 100
skeezix is on a distinguished road
Default

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...? All of the tables in my other Excel files (around 50 or so tables in 4 files) were created the same way, but only the one table in the file I uploaded had any problems, and then it was only after several years.



Unfortunately, the Parameters list on the right of your images do not easily correspond to what I have in my Excel 2000, so it's kinda difficult to compare. But I would like to thank you anyway for the time and trouble you spent working on my problem.


Everything works correctly now. Not sure what the problem was. By copying the file from one drive to another and then back to the original drive, I was able to open my file and have the table come up correctly, so I think I'm okay now. (That process, by the way, took me a few hours of fiddling around to get the file to open and close correctly. Go figger.)
__________________
* HP Pavilion Desktop 510-p114
* Windows 10 Home 22H2 19045.4123; Office 2000
Reply With Quote
  #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: 344
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
  #6  
Old 03-17-2023, 12:05 PM
p45cal's Avatar
p45cal p45cal 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 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Quote:
Originally Posted by skeezix View Post
I don't understand what a "proper" table is. Maybe it's something other than what Excel 2000 provides...?
I think back then they were called Lists. You can select your table cells or a cell within that table, then Data|List|Create List… (or Ctrl +L)
Reply With Quote
  #7  
Old 03-19-2023, 05:28 AM
xor xor is offline Y Values in Chart Do Not Update When a Row Is Added to the Table Windows 11 Y Values in Chart Do Not Update When a Row Is Added to the Table Office 2021
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

In the sheet ARM I have set up formulas so that the chart automatically should update, including dates.
Attached Files
File Type: xls ARM.xls (62.0 KB, 4 views)
Reply With Quote
  #8  
Old 03-19-2023, 10:56 AM
skeezix skeezix 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 97-2003
Competent Performer
Y Values in Chart Do Not Update When a Row Is Added to the Table
 
Join Date: Jan 2019
Posts: 100
skeezix is on a distinguished road
Default

Thank you, I appreciate it. I'll take a look at it.
__________________
* HP Pavilion Desktop 510-p114
* Windows 10 Home 22H2 19045.4123; Office 2000
Reply With Quote
  #9  
Old 03-25-2023, 12:48 AM
xor xor is offline Y Values in Chart Do Not Update When a Row Is Added to the Table Windows 11 Y Values in Chart Do Not Update When a Row Is Added to the Table Office 2021
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Was post #7 of any help?
Reply With Quote
  #10  
Old 03-25-2023, 07:51 AM
skeezix skeezix 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 97-2003
Competent Performer
Y Values in Chart Do Not Update When a Row Is Added to the Table
 
Join Date: Jan 2019
Posts: 100
skeezix is on a distinguished road
Default

Hi xor,


In your message you wrote that you "...set up formulas so that the chart automatically...". I looked at ARM.xls and searched for formulas. Using the ASAP Utilities app I searched for formulas and the app did not find any in the ARM.xls file.


I did manage to recreate the worksheet table and chart though, by copying the table, pasting it into Notepad, copying it from Notepad and then pasting it back into where it came from in the worksheet.


I appreciate your help, and am saving ARM.xls just in case the problem returns.
__________________
* HP Pavilion Desktop 510-p114
* Windows 10 Home 22H2 19045.4123; Office 2000
Reply With Quote
  #11  
Old 03-25-2023, 09:00 AM
p45cal's Avatar
p45cal p45cal 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 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Quote:
Originally Posted by skeezix View Post
I searched for formulas and the app did not find any in the ARM.xls file
They're in the Name Manager and the chart plots those names.
Reply With Quote
  #12  
Old 03-26-2023, 12:05 AM
xor xor is offline Y Values in Chart Do Not Update When a Row Is Added to the Table Windows 11 Y Values in Chart Do Not Update When a Row Is Added to the Table Office 2021
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

@Skeezix

Please write back if you need further explanation.
Reply With Quote
  #13  
Old 03-27-2023, 08:17 AM
skeezix skeezix 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 97-2003
Competent Performer
Y Values in Chart Do Not Update When a Row Is Added to the Table
 
Join Date: Jan 2019
Posts: 100
skeezix is on a distinguished road
Default

Quote:
Originally Posted by p45cal View Post
They're in the Name Manager and the chart plots those names.

Hmmm... My Excel 2000 does not have a Name Manager. It does have a Name function when I pull the Insert menu down, and that function has Define, Create, Paste, Apply, and Label options. Since beginning with Excel in 2000, I have never used the Name function and I have quite a few tables that do have formulas in them. However, this particular XLS file does not contain any formulas.



@XOR
No, I have utilized the help that was given to me and I was able to fix the problem, so I don't think I need any more explanation.
__________________
* HP Pavilion Desktop 510-p114
* Windows 10 Home 22H2 19045.4123; Office 2000
Reply With Quote
  #14  
Old 03-27-2023, 08:33 AM
p45cal's Avatar
p45cal p45cal 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 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Quote:
Originally Posted by skeezix View Post
Hmmm... My Excel 2000
Gosh.
The names and formulae are:
2023-03-27_163117.png


Highly recommended utility that was used a lot 'back in the day' before Microsoft caught up with their own:
Free Name Manager Excel add-in
Reply With Quote
Reply

Thread Tools
Display Modes


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 01:32 PM.


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