Hello, please see attached picture, I need to make excel 2010 chart square.
As background I have made a picture the excel chart is not square, I verified by making screen capture and
comparing axes in image editor.
How to remove white space on the sides?
Hi,
Can't you just set the height and width to the same value in the Chart Tools - format size menu?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
But I have set the size the same, why excel leaves this white space at the sides there is no legend or anything.Originally Posted by Richard Buttrey
I found the problem ! I had locked the acpect ratio before making the size equal and that did not allow me to resize chart to fit into specified size.
This is almost a bug, at least tricky.
Is there a way to remove, hide the zero from where the axis starts?
Seems to be as easy as
Go to “Number” tab. Select “Custom”
Specify the custom formatting code as #,##0;-#,##0;
Last edited by smile0; 05-29-2012 at 05:59 PM.
It seems I spoke too soon, the chart is still not rectangular, see attached xls file
Hi,
The chart is square, the plot area isn't.
So just move the plot area as far as it will go into the upper left hand corner of the chart then drag the plot lower right corner down to the chart lower right corner. To ensure it's square temporarily add a straight line and place the line ends at the chart top left and bottom right. Then click the plot area to check that the line cuts through the plot corners. Adjust as necessary.
Fot some reason the gap is wider on the sides, see attached picture, how to make it equal in size?
The gap is there for the axes. When you select the plot area and attempt to resize it you should see 2 sets of dotted lines.
The inner set if the plotarea itself the outer is the area required for axis labelling. If you remove the horizontal axis you will see the gap between plotarea and inside plotarea is reduced. You can now increase the plot area size and reduce the side gaps. Of course you will have no axis labelling.
Well it seems really strange that in my original document xlsm I could not resize the chart, in my xlsx it it possible if I drag the chart plot area.
See attached picture.
I can't understand how microsoft can include new functions in office 2010 when chart feature is very limited.
- No GUI to align the plot area in chart area
- No GUI to set plot area size, or margins
- The rectangular chart axis gradations are not equal in size even if you make chart rectangular
I mean everyone in math know that that x and y axis gradations must be the same, microsoft does not.
I understand that it scales the axis if the chart is not rectangular, but otherwise it is making a bad chart.
I found some VBA code to rezise the chart plot area, then another code to aligh it, then another to rezise the axis gradations, come on it is crazy that sutch basic functions must be googled to be used.
Simplest and quickest way to force the plot area to be square is to add a dummay data series and change the chart type to Pie.
There is no UI for position any elements within a chart.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks