Opening an Excel-sheet with Numbers, compatability issue

Numbers does a pretty good job of opening Excel documents but some elements (including some charts) don't translate well and you need to re-implement them in Numbers, saving as a Numbers document.

If you wish to post more specifics (with screenshots) someone here may be able to help you with that.

SG

I think this something similar can be done in Numbers but can you explain the relationship between the table and the chart? It's a little hard to tell what numbers are being charted.

Csound1's usual suggestion to use LibreOffice won't work on iOS, though Excel for iOS works well. If you don't want to take the time to rework the chart you might give Excel for iOS a spin.

SG

It looks to me like those extra lines aren't plotted by that data set, most likely lines that are drawn on top of the chart?

i.e. I don't see any data on that table that would put lines where they show up on the original excel file.

Look at the original chart and see if you can select and move those lines, they might show as one group of lines, or as a part of the chart if everything is "grouped" together. just right click and ungroup to see the individual parts.

If that is the case then you can recreate the same exact thing using numbers, because you cna draw the same type of lines over a numbers chart too.

If they are plotted lines, then your data isn't coming from that table but another supporting table that has the additional lines called out. (most likely referencing back to this table for the calculations being plotted against the static lines)

Jason

You can use a compatible app, a free one such as LibreOffice will open without messing them up and without costing you any money.

Forgot that Libre has no IOS version, but Excel is a fine substitute for it.