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
Looks OK when I try it: https://www.dropbox.com/s/9hbobwtzeacw6o5/Internet.xlsx?dl=1
Hi Chris
Maybe you and Hans have different versions of Excel installed. Current versions are 16.59 and 16.60
Check your version. Go to the menu bar and choose Excel > About Microsoft Excel to display your version number. What version are you running?
16.59 is the current version.
By trial and error I have discovered that what forces the change to the haywire display is selecting a data range beyond the currently available data. How can I set a data range for the whole column which keeps the display normal?