Share via

The data range is too complex to be displayed

Anonymous
2013-07-20T11:27:19+00:00

Hello,

I have this problem of data range is too complex.. I have 2 columns in my excel sheet.. each column has 100 rows. both the columns have just numbers ... I am showing an example here.  I am trying to draw a graph for these two quantities. i have selected XY chart and selected All the cells of Distance for X axis and Mag_E for y axis.  But i am getting this message of The data range is too complex. It is a very simple plot and i wonder how the excel failed to execute it. Can somebody enlighten me here?

Distance [mm] Mag_E  [V_per_meter]
0.00 1540.46
0.80 414.48
1.61 481.04
2.41 504.64
3.21 522.03
4.02 539.75
4.82 559.14
5.63 580.05
6.43 601.97
7.23 624.09
8.04 646.18
8.84 667.01
Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-07-20T13:12:14+00:00

    it the data is surrounded by blank cells or borders: click on any cell in the data

    Otherwise select all the data

    Use Insert | Charts and Excel makes the chart.

    If this fails: go to my webpage to get my email address and send me the file.

    best wishes

    0 comments