ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Excel Chart Scaling (https://www.excelbanter.com/charts-charting-excel/191066-excel-chart-scaling.html)

Crazyish1

Excel Chart Scaling
 
I need to print a chart such that the scale is the same on the x-axis and
y-axis. I need to print this chart such that the scale size is the same
(prints 1:1) (the number of pixels between each tick is the same on both
axes). Other than manually changing the dimensions of the graph until the
gridlines form a square is there another way?

Hopefully there a piece of VB code that can automatically set this.

Jon Peltier

Excel Chart Scaling
 
Try this:

http://peltiertech.com/Excel/Charts/SquareGrid.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Crazyish1" wrote in message
...
I need to print a chart such that the scale is the same on the x-axis and
y-axis. I need to print this chart such that the scale size is the same
(prints 1:1) (the number of pixels between each tick is the same on both
axes). Other than manually changing the dimensions of the graph until the
gridlines form a square is there another way?

Hopefully there a piece of VB code that can automatically set this.





All times are GMT +1. The time now is 10:04 AM.

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