Excel cannot create or use the data range reference

Copper Contributor

Hi, 

I  am facing this error when i m filter my data and press Alt+;(semicolon).

please help me to resolve this.

I tried sort formula A to Z and Z to A, but it not worked.

 

Microsoft Office Excel

Microsoft Office Excel cannot create or use the data range reference because it is too complex. Try one or more of the following:

Use data that can be selected in one contiguous rectangle.

• Use data from the same sheet.

OK

5 Replies

@Anoop555 

This error message appears when Excel cannot create or use the data range reference because it is too complex.

You get that "data range too complex to display" message when the ranges that the chart uses are not contiguous or are on different sheets. Check if the chart uses are not contiguous.

 

If this doesn’t work…you mentioned that you tried sorting formula A to Z and Z to A but it didn’t work. You can try sorting(by A to Z or Z to A.) based on the filter column first and then check the result.

 

Hope it helps!

Hi
Microsoft Office Excel cannot create or use the data range reference because it is too complex. Try one or more of the following:
Use data that can be selected in one contiguous rectangle.
• Use data from the same sheet

@Anoop555 

One reason I find this error popping up is if the x and y data are in rows instead columns.