EXcel chart not showing all data

Question

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

Answer 1

Use dynamic named ranges (or a table) as source data.

See https://www.dropbox.com/s/7jzqrmvni5i0gjg/InternetNew.xlsx?dl=1

Answer 2

Could you create a stripped-down copy of the workbook (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.

Answer 3

Here's a link to the file https://1drv.ms/u/s!Ar_iK0lq7LHygpsyv7-areHCEMUtUA?e=Vw2X4m 

RD chart and DT chart both exhibit the same behaviour.

TIA

Answer 4

I clicked on the RD Chart, then clicked Select Data on the Chart Design tab of the ribbon.

In the Select Data Source dialog, the Chart data range is specified as

='Rowan Dartington'!$O$1:$R$899

But if you look at the Rowan Dartington sheet, you'll see that the data extend to row 918. If you change the Chart data range to

='Rowan Dartington'!$O$1:$R$918

you'll see all data in the chart.

Answer 5

Thanks, I got that, and the other values: Legend entries Y values and the Horizontal axis labels change automatically.

But the chart formatting goes haywire.