Are you adding new data to a range of cells and then wish to automatically update the chart?
![]() |
Patch reliability is unclear, but widespread attacks make patching prudent. Go ahead and patch, but watch out for potential problems. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Auto updates
Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Auto updates
- This topic has 2 replies, 2 voices, and was last updated 23 years, 10 months ago.
AuthorTopicWSkmedgyes
AskWoody LoungerJune 22, 2001 at 8:27 pm #357303Viewing 1 reply threadAuthorReplies-
WSkmedgyes
AskWoody LoungerJune 22, 2001 at 9:27 pm #530572> I can of course updated by double clicking on the range and then dragging it to include the new data,<
It seems to me that you can do this with a VBA macro.
1. Identify the new data range, first cell/last cell
2. Assign the range (as a string value) to the chart property that needs it.
3. Initiate the action with a button on the sheet(s)What do you think?
-
WSJohn Jacobson
AskWoody LoungerJune 23, 2001 at 12:02 am #530580Set your chart series to extend 1 row beyond the last row of data. As long as the new data row is inserted and not pasted on top of that blank row, your chart series will automatically expand to include the inserted row.
You’ll have to tolerate one empty column at the right of your charts, which shouldn’t bother anyone. Or you can change all charts to line charts, and have some more options about shifting axes. This method doesn’t work well with area charts, which zoom down to zero on any blank point in their series.
Aloha,
JohnJ
Viewing 1 reply thread -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Image for Windows TBwinRE image not enough space on target location
by
bobolink
3 hours, 24 minutes ago -
Start menu jump lists for some apps might not work as expected on Windows 10
by
Susan Bradley
4 hours, 9 minutes ago -
Malicious Go Modules disk-wiping malware
by
Alex5723
3 hours, 1 minute ago -
Multiple Partitions?
by
CWBillow
11 minutes ago -
World Passkey Day 2025
by
Alex5723
11 hours, 44 minutes ago -
Add serial device in Windows 11
by
Theodore Dawson
1 day, 2 hours ago -
Windows 11 users reportedly losing data due forced BitLocker encryption
by
Alex5723
12 minutes ago -
Cached credentials is not a new bug
by
Susan Bradley
1 day, 7 hours ago -
Win11 24H4 Slow!
by
Bob Bible
1 day, 7 hours ago -
Microsoft hiking XBox prices starting today due to Trump’s tariffs
by
Alex5723
1 day, 4 hours ago -
Asus adds “movement sensor” to their Graphics cards
by
n0ads
1 day, 9 hours ago -
‘Minority Report’ coming to NYC
by
Alex5723
1 day, 6 hours ago -
Apple notifies new victims of spyware attacks across the world
by
Alex5723
1 day, 18 hours ago -
Tracking content block list GONE in Firefox 138
by
Bob99
1 day, 17 hours ago -
How do I migrate Password Managers
by
Rush2112
1 day, 1 hour ago -
Orb : how fast is my Internet connection
by
Alex5723
1 day, 3 hours ago -
Solid color background slows Windows 7 login
by
Alex5723
2 days, 6 hours ago -
Windows 11, version 24H2 might not download via Windows Server Updates Services
by
Alex5723
2 days, 4 hours ago -
Security fixes for Firefox
by
Susan Bradley
1 day, 5 hours ago -
Notice on termination of services of LG Mobile Phone Software Updates
by
Alex5723
2 days, 16 hours ago -
Update your Apple Devices Wormable Zero-Click Remote Code Execution in AirPlay..
by
Alex5723
3 days, 2 hours ago -
Amazon denies it had plans to be clear about consumer tariff costs
by
Alex5723
2 days, 17 hours ago -
Return of the brain dead FF sidebar
by
EricB
2 days, 4 hours ago -
Windows Settings Managed by your Organization
by
WSDavidO61
1 day, 7 hours ago -
Securing Laptop for Trustee Administrattor
by
PeachesP
9 hours, 16 minutes ago -
The local account tax
by
Susan Bradley
2 days, 5 hours ago -
Recall is back with KB5055627(OS Build 26100.3915) Preview
by
Alex5723
3 days, 15 hours ago -
Digital TV Antenna Recommendation
by
Win7and10
3 days, 7 hours ago -
Server 2019 Domain Controllers broken by updates
by
MP Support
4 days, 2 hours ago -
Google won’t remove 3rd party cookies in Chrome as promised
by
Alex5723
4 days, 4 hours ago
Recent blog posts
Key Links
S | M | T | W | T | F | S |
---|---|---|---|---|---|---|
1 | 2 | 3 | ||||
4 | 5 | 6 | 7 | 8 | 9 | 10 |
11 | 12 | 13 | 14 | 15 | 16 | 17 |
18 | 19 | 20 | 21 | 22 | 23 | 24 |
25 | 26 | 27 | 28 | 29 | 30 | 31 |
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.