#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
The attached Excel file demonstrates the problem.
__________________
* HP Pavilion Desktop 510-p114 * Windows 10 Home 22H2 19045.4123; Office 2000 |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
Quote:
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. |
#6
|
||||
|
||||
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)
|
#7
|
|||
|
|||
In the sheet ARM I have set up formulas so that the chart automatically should update, including dates.
|
#8
|
|||
|
|||
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 |
#9
|
|||
|
|||
Was post #7 of any help?
|
#10
|
|||
|
|||
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 |
#11
|
||||
|
||||
They're in the Name Manager and the chart plots those names.
|
#12
|
|||
|
|||
@Skeezix
Please write back if you need further explanation. |
#13
|
|||
|
|||
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 |
#14
|
||||
|
||||
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 |
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 |
Table with values from several locations and years - need to find comp values | Ricardo Sousa | Excel | 6 | 06-09-2018 10:51 PM |
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 |