I am on Numbers 10.1/Catalina. Have multi-sheet spreadsheet going back few generations of Numbers and OS. My pie charts have permanent outline that I can't remove. Also, graphs retained the last generation look (gaps between wedges etc). When I create new, blank file, copy and paste one of my tables and create new graph, it looks fine - no outline and new aesthetics.
Is there a way to "update" my existing spreadsheet to the new looks?
MacBook Pro, OS X 10.11
Out of curiosity, is this the outline you cannot remove, the one that goes around the entire chart? If so, it is almost assuredly from Excel.
Did this file start out as Excel file way back when? I do not have any old native Numbers files with me at the moment to play with but I do know that imported Excel files often have outlines around charts that cannot easily be removed and all new charts made in Numbers will have the same Excel-like formatting. I just now created an Excel file with a line chart and pie chart and imported that file into Numbers. There is an outline around each chart with no setting that I find to remove it, spaces between the pie wedges with no setting that removes them, and all new charts I make look just like those ones.
All is not lost, though, if you need to use your original file. Although this is an imperfect solution, it seems to work. Create a new Numbers document with a small table and the charts you want, formatted the way you want to see them. The data in the table can be gibberish, the chart styles are what we want out of this. Copy the charts and paste them into your other file. Then, for each, Copy Style then Paste Style onto the charts that are not formatted properly. Those charts should now have the correct Numbers formatting.
I say it is an imperfect solution because new charts will be created with the Excel-like formatting. Personally, when I have problems like this with an imported Excel file, I use your other solution of starting over with a fresh new Numbers document.
As far as I remember, it started in Numbers. I got the result I wanted by copying a table to a new sheet, creating a chart and then copying it back to the original sheet, redoing data references once there. Your idea is so much simpler, I didn't think of copying and pasting just the style. And you are right, new charts are created in the "old" style. Re-doing the lot is not an option with 30+ sheets, all cross referenced. Thanks for your help!
You could be right there, digging deep into the soft tissue :-) I remember now that I used to have MS Office for Mac. Entirely possible that my spreadsheet started there. Anyway, I have defined new style using rejigged graphs and now can apply it to any new graph that I'll need in the future. Thanks again for the idea.
The outline goes around the entire chart, but it isn't fixed in size. It will expand when I change label's distance from centre. So it is "live" and connected to data.
That looks like the pie chart I made in Excel then tried to format in Numbers. Same space between the wedges that you cannot remove. Same border (which expands when you move the value labels outward). I made another with your data and colors, starting in Excel and doing the final formatting in Numbers:
Unable to remove graph border
