Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Different unit distance on axis
I would like both of the axis to have the same distance between their units. I manage to make it so that both axis increase by 1 by each tick, but the physical distance between each tick is not the same on both axis. The x-axis might have 2cm between each tick, while the y-axis has 3cm. This creates a false impression of what the graph actually looks like. I know I can drag the window sideways or up and down to change this, but that would only be approximate. Anyone? -- Siberian ------------------------------------------------------------------------ Siberian's Profile: http://www.excelforum.com/member.php...o&userid=25361 View this thread: http://www.excelforum.com/showthread...hreadid=388441 |
#2
|
|||
|
|||
Hi,
Maybe this article will help. http://peltiertech.com/Excel/Charts/SquareGrid.html Cheers Andy Siberian wrote: I would like both of the axis to have the same distance between their units. I manage to make it so that both axis increase by 1 by each tick, but the physical distance between each tick is not the same on both axis. The x-axis might have 2cm between each tick, while the y-axis has 3cm. This creates a false impression of what the graph actually looks like. I know I can drag the window sideways or up and down to change this, but that would only be approximate. Anyone? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Thanks, I suppose this will help me, but I'm totally new to VBA (don't even know what it stands for) and so it looks a bit scary. Do I need to install something else? Will I find the text that is written on this page somewhere, and then edit it, or am I supposed to write it from scratch? -- Siberian ------------------------------------------------------------------------ Siberian's Profile: http://www.excelforum.com/member.php...o&userid=25361 View this thread: http://www.excelforum.com/showthread...hreadid=388441 |
#4
|
|||
|
|||
No need to be scared ;)
You should not need to install anything else. The code can be copied from the page, just highlight the text and CTRL+C. Use CTRL+V within a code module to paste code. Jon also has some explanation of VBA (Visual Basic for Applications) on his site. If you get really lost post back. Cheers Andy Siberian wrote: Thanks, I suppose this will help me, but I'm totally new to VBA (don't even know what it stands for) and so it looks a bit scary. Do I need to install something else? Will I find the text that is written on this page somewhere, and then edit it, or am I supposed to write it from scratch? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
|
|||
|
|||
Seems overly complicated to me. If it fits into what you want to accomplish, why not force the plotarea to be squa sub squarechart() With activechart.plotarea h=.height .width=h end with end sub this will force the plotarea to be square. I'm not sure how closely this will force the axes to be equal in length, but that could be checked (using the height/width properties of the axis object) and the width/height of the plotarea adjusted accordingly. Note that I've assumed that height is the smaller dimension. If width is the smaller dimension, switch the height and width accordingly. -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=388441 |
#6
|
|||
|
|||
Seems overly complicated to me. If it fits into what you want to accomplish, why not force the plotarea to be squa sub squarechart() With activechart.plotarea h=.height .width=h end with end sub this will force the plotarea to be square. I'm not sure how closely this will force the axes to be equal in length, but that could be checked (using the height/width properties of the axis object) and the width/height of the plotarea adjusted accordingly. Note that I've assumed that height is the smaller dimension. If width is the smaller dimension, switch the height and width accordingly. -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=388441 |
#7
|
|||
|
|||
If it fits into what you want to accomplish, why not force the plotarea to be squa sub squarechart() With activechart.plotarea h=.height .width=h end with end sub this will force the plotarea to be square. I'm not sure how closely this will force the axes to be equal in length, but that could be checked (using the height/width properties of the axis object) and the width/height of the plotarea adjusted accordingly. Note that I've assumed that height is the smaller dimension. If width is the smaller dimension, switch the height and width accordingly. -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=388441 |
#8
|
|||
|
|||
If it fits into what you want to accomplish, why not force the plotarea to be squa sub squarechart() With activechart.plotarea h=.height .width=h end with end sub this will force the plotarea to be square. I'm not sure how closely this will force the axes to be equal in length, but that could be checked (using the height/width properties of the axis object) and the width/height of the plotarea adjusted accordingly. Note that I've assumed that height is the smaller dimension. If width is the smaller dimension, switch the height and width accordingly. -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=388441 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
Moving selected data | Excel Worksheet Functions | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |