|
||||||||||||||||||||
|
|||||||||||||||||||||
|
|||||||
 |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
04-08-2005, 04:06 PM
|
|||
|
|||
|
I would like to see a Graph in X-Y. This was available in 123 for.
In Lotus 123 I had the possibilty to have an actual X-Y graph which always
kept its the relation between the 2 axes. In excel I use the spreaded graph but I always have to change the dimension. I use it to draw 2 dimensional figures in the spreadsheet. 
|
|
#2
04-08-2005, 05:06 PM
|
|||
|
|||
|
Re: I would like to see a Graph in X-Y. This was available in 123 for.
Not sure I understand what you want to do but you might want to check
out the XY Scatter chart (as opposed to the Line chart). -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article <FB395E2D-CBF2-41FA-8296-6A2AEC6EF069@microsoft.com>, RCordewener@discussions.microsoft.com says... > In Lotus 123 I had the possibilty to have an actual X-Y graph which always > kept its the relation between the 2 axes. > In excel I use the spreaded graph but I always have to change the dimension. > I use it to draw 2 dimensional figures in the spreadsheet. >
|
|
#3
04-10-2005, 07:06 PM
|
|||
|
|||
|
Re: I would like to see a Graph in X-Y. This was available in 123for.
You can use VBA procedures to modify the axes in ways that are not built
into Excel. To make the gridlines equally spaced in the X and Y directions, try this: http://peltiertech.com/Excel/Charts/SquareGrid.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ RCordewener wrote: > In Lotus 123 I had the possibilty to have an actual X-Y graph which always > kept its the relation between the 2 axes. > In excel I use the spreaded graph but I always have to change the dimension. > I use it to draw 2 dimensional figures in the spreadsheet.
|
|
#4
04-28-2005, 06:06 PM
|
|||
|
|||
|
Re: I would like to see a Graph in X-Y. This was available in 123
This code makes the axes 1:1 on the monitor (which was much more than I could
do), but when I printed it out, Excel still flattened the graph. Is there a way to make Excel print a graph with axes scaled 1:1? Other than trial and error? "Jon Peltier" wrote: > You can use VBA procedures to modify the axes in ways that are not built > into Excel. To make the gridlines equally spaced in the X and Y > directions, try this: > > http://peltiertech.com/Excel/Charts/SquareGrid.html > > - Jon > ------- > Jon Peltier, Microsoft Excel MVP > Peltier Technical Services > Tutorials and Custom Solutions > http://PeltierTech.com/ > _______ > > RCordewener wrote: > > > In Lotus 123 I had the possibilty to have an actual X-Y graph which always > > kept its the relation between the 2 axes. > > In excel I use the spreaded graph but I always have to change the dimension. > > I use it to draw 2 dimensional figures in the spreadsheet. >
|
|
#5
04-30-2005, 08:11 AM
|
|||
|
|||
|
Re: I would like to see a Graph in X-Y. This was available in 123
Select the chart, then select File | Page Setup... | Chart tab. Select
the 'Custom' size option. I *believe* that will retain the shape of the chart. Alternatively, select the cells beneath the chart and print them at 100% scaling. -- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 In article <C3C6DEA1-B40D-45BA-8D63-D668986457A2@microsoft.com>, =?Utf- 8?B?S2FyZW4gR2lic29u?= <Karen Gibson@discussions.microsoft.com> says... > This code makes the axes 1:1 on the monitor (which was much more than I could > do), but when I printed it out, Excel still flattened the graph. Is there a > way to make Excel print a graph with axes scaled 1:1? Other than trial and > error? > > "Jon Peltier" wrote: > > > You can use VBA procedures to modify the axes in ways that are not built > > into Excel. To make the gridlines equally spaced in the X and Y > > directions, try this: > > > > http://peltiertech.com/Excel/Charts/SquareGrid.html > > > > - Jon > > ------- > > Jon Peltier, Microsoft Excel MVP > > Peltier Technical Services > > Tutorials and Custom Solutions > > http://PeltierTech.com/ > > _______ > > > > RCordewener wrote: > > > > > In Lotus 123 I had the possibilty to have an actual X-Y graph which always > > > kept its the relation between the 2 axes. > > > In excel I use the spreaded graph but I always have to change the dimension. > > > I use it to draw 2 dimensional figures in the spreadsheet. > > >
|
|
#6
04-30-2005, 11:06 PM
|
|||
|
|||
|
Re: I would like to see a Graph in X-Y. This was available in 123
This still results in a slight flattening, so it will take one trial to determine
how much to fudge it by. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Tushar Mehta wrote: > Select the chart, then select File | Page Setup... | Chart tab. Select > the 'Custom' size option. I *believe* that will retain the shape of the > chart. > > Alternatively, select the cells beneath the chart and print them at 100% > scaling. >
|
|
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
