Level 1

51 points

Make Charts keep same Dimensions

Is there any solution to permanently fix charts to stay the same size? If I change inputs for X and Y (I'm not changing the inputs in any dramatic or unreasonable way) the charts move even with Lock on?

All I've done is flip cell values D7 and D8 but this makes the charts change size as can be seen from the grey "crosshair" dividing all 4 charts in the second image.

This means there is little point in charting anything in Numbers because the charts always change / move, the same applies to a smaller bank of 20 charts to the right of these main 4.

Am I the only user with this issue?

Cheers!

MacBook Pro 15″

Posted on Jul 30, 2023 10:03 AM

Top-ranking reply

Badunit

Level 7

30,942 points

Posted on Aug 18, 2023 1:21 PM

Looking at the series colors and the white space around the chart and a border around that white space, it is apparent these charts started in Excel. Odd things can happen with Excel charts and formatting. One problem in particular is chart borders. Numbers imports that feature but gives us no way to edit it.

After some minor playing around with Excel, it looks like if you turn off the chart borders before saving the file it may work correctly when it is imported. I cannot guarantee it for you but I see the jumping around when I start with Excel chart borders on and am not seeing it when they are off.

I have no problem with Numbers charts in native Numbers documents but imported Excel files come with their own chart styles, replacing all the Numbers styles. I have problems with charts created in Numbers if the file was imported from Excel.

View in context

Similar questions

28 replies

Bardonicloud Author

Level 1

51 points

Sep 13, 2023 3:34 AM in response to Badunit

I have tried to get this new sheet's charts to remain fixed in size/position but if I change the calculators Asset Prices from £/$ to the Dow Jones (with numbers like 12100 changing to 33000) the borders of the chart or the chart itself changes size/position and I am not sure how to remedy it? I have built a new sheet and copied the old tables and charts and reformatted the charts to Apple but they still move?

Cheers for any help, as this new different rebuilt sheet should have fixed charts like the sheet I was referring to a the very top of this thread.

Bardonicloud Author

Level 1

51 points

Oct 9, 2023 3:35 AM in response to Badunit

Yes, each chart was reformatted.

"no white background around the chart+title"

I just reselected the chart format (first chart style icon) and this is what it looks like as a Numbers formatted chart -- it has a white bkgr though? (I've dragged the chart down and to the right to show what it's gridded background look like too).

Bardonicloud Author

Level 1

51 points

Oct 10, 2023 2:33 PM in response to Badunit

Thank you so much for spending the time to further explain what might be/is happening with these chart sizes @Badunit!

Re:

"The imported document after I selected the chart and clicked the top left table style in that document (which is not a necessary step, I did it just to show what might happen):"

Image 3: I was wondering why doesn't the chart conform to the Numbers Format Style selection and make it turn into a Numbers chart like in the last image? Why the need for the extra step of:

"Copy/Pasted the table&chart from the imported document into the new document"

Bardonicloud Author

Level 1

51 points

Aug 1, 2023 6:23 AM in response to Yellowbox

Converted to to Excel and it works perfectly because I can use any values in D7 and D8 and the charts stay the same size... is there a way to make Apple Charts do the same thing?

Bardonicloud Author

Level 1

51 points

Aug 18, 2023 7:47 AM in response to Bardonicloud

iWork contacted me and are currently looking at the issue.

Yellowbox

Level 7

21,963 points

Aug 18, 2023 8:48 AM in response to Bardonicloud

Hi Bardonicloud,

Thanks for keeping fellow users in the loop. It will be good to hear from you if Apple can help.

Regards,

Ian.

Bardonicloud Author

Level 1

51 points

Aug 23, 2023 10:12 AM in response to Badunit

Not sure... it doesn't look like either of them when I select a large chart and then look at my Chart Styles in the top right:

Bardonicloud Author

Level 1

51 points

Aug 26, 2023 7:10 AM in response to Bardonicloud

This is what a "copied" chart looks like?

Bardonicloud Author

Level 1

51 points

Aug 26, 2023 7:33 AM in response to Bardonicloud

Solution: I can paste a copied chart into a new document only if I select away from the mass of my tables and charts in the new document i.e. select the white space that is not tables and charts.

Bardonicloud Author

Level 1

51 points

Sep 14, 2023 2:39 AM in response to Bardonicloud

I forgot to post the second image showing the charts moved up and now covering the blue celled reference data S, K, IV.

Bardonicloud Author

Level 1

51 points

Sep 27, 2023 3:04 AM in response to Bardonicloud

Wondering if you have any ideas @Badunit? Cheers

Badunit

Level 7

30,942 points

Sep 27, 2023 2:37 PM in response to Bardonicloud

Other than it still looks like an Excel chart with Excel chart formatting, I don't know what could still be wrong.

Bardonicloud Author

Level 1

51 points

Oct 5, 2023 9:55 AM in response to Badunit

It was a brand new sheet and charts with the tables copied over?

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Make Charts keep same Dimensions