ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Making Excel charts with exactly the same size (https://www.excelbanter.com/charts-charting-excel/93087-making-excel-charts-exactly-same-size.html)

anderssweden

Making Excel charts with exactly the same size
 
I am amking a report and I have several diagrams that I want to have the same
size (exact). However, I only manage to change the size of the diagram-"bok"
numerically. How can you fix the size of the actual diagram numerically (and
not by mouse)? Anyone? Please need answer fast!


Bernard Liengme

Making Excel charts with exactly the same size
 
If you hold ALT down while dragging chart area borders, the chart is made to
align exactly with the cell boundaries.
Any help?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"anderssweden" wrote in message
...
I am amking a report and I have several diagrams that I want to have the
same
size (exact). However, I only manage to change the size of the
diagram-"bok"
numerically. How can you fix the size of the actual diagram numerically
(and
not by mouse)? Anyone? Please need answer fast!




Gklass

Making Excel charts with exactly the same size
 
This add-in does it:

http://j-walk.com/ss/excel/files/charttools.htm

But it only does it for the whole chart, not the plot area.
to do that use the chart tools and maximize the plot are

Bernard Liengme wrote:
If you hold ALT down while dragging chart area borders, the chart is made to
align exactly with the cell boundaries.
Any help?



All times are GMT +1. The time now is 07:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com