This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I've noticed that a chart I use does not show all the data available. The last data point showing in all 3 series is 2 March 2022, but there is data for all dates after that up to today. Any help will be appreciated
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Use dynamic named ranges (or a table) as source data.
See https://www.dropbox.com/s/7jzqrmvni5i0gjg/InternetNew.xlsx?dl=1
I had forgotten all about dynamic named ranges!
Many thanks: this is a great solution!