| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I get VBA to generate a chart with square axes?
I have generated a chart using Excel data but wish to ensure that the chart
is square (i.e. the x and the y axes are to the same scale). an anyone help please? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I get VBA to generate a chart with square axes?
Try this:
'--------- Sub SquareChart() With ActiveSheet.Shapes("Graphique 1") .Height = .Width End With End Sub '--------- Regards, -- AP "patrick" a écrit dans le message de news: ... I have generated a chart using Excel data but wish to ensure that the chart is square (i.e. the x and the y axes are to the same scale). an anyone help please? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I get VBA to generate a chart with square axes?
Thanks for this. I have found some code that allows me to square my charts BUT
I would also like to be able to scale the grid squares on my chart - e.g. each Major Unit is 1 centimetre. This will require scaling of both height and width to maintain the square grid. All help appreciated - thanks Patrick "Ardus Petus" wrote: Try this: '--------- Sub SquareChart() With ActiveSheet.Shapes("Graphique 1") .Height = .Width End With End Sub '--------- Regards, -- AP "patrick" a écrit dans le message de news: ... I have generated a chart using Excel data but wish to ensure that the chart is square (i.e. the x and the y axes are to the same scale). an anyone help please? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I get VBA to generate a chart with square axes?
This will get you part of the way:
http://peltiertech.com/Excel/Charts/SquareGrid.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "patrick" wrote in message ... Thanks for this. I have found some code that allows me to square my charts BUT I would also like to be able to scale the grid squares on my chart - e.g. each Major Unit is 1 centimetre. This will require scaling of both height and width to maintain the square grid. All help appreciated - thanks Patrick "Ardus Petus" wrote: Try this: '--------- Sub SquareChart() With ActiveSheet.Shapes("Graphique 1") .Height = .Width End With End Sub '--------- Regards, -- AP "patrick" a écrit dans le message de news: ... I have generated a chart using Excel data but wish to ensure that the chart is square (i.e. the x and the y axes are to the same scale). an anyone help please? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I a rotate my square radar chart (square-diamond)? | Charts and Charting in Excel | |||
| Excel chart with a square axis | Excel Discussion (Misc queries) | |||
| how to center a square plot area in a square chart | Charts and Charting in Excel | |||
| How to make the gridlines of a chart square | Charts and Charting in Excel | |||
| Locking gridlines to be square - axes to same scale ? | Charts and Charting in Excel | |||
Hybrid Mode
