If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Plot a line? Set dymanic axis Max min
Hi all,
two questions: 1. I have a scatter plot of returns and I want to add not a trend line but simply x=y line to my plot (and other equations) Any way to do this? 2. I need to control both my x and y axis, I want to max and min and scale numbers to be linked to a cell in my spreadsheet instead of simply being static values or auto. THANKS! Stan |
#2
|
|||
|
|||
Stan,
Regarding question 1, you can add equations to charts by plotting points in an Excel worksheet and then charting those points. For more detailed information, Stephen bullen has some excellent examples of how to plot functions . . . http://www.bmsltd.ie/Excel/Default.htm Regarding question 2, please refer to Jon's site for how to create dynamic charts . . . http://peltiertech.com/Excel/Charts/...umnChart1.html http://peltiertech.com/Excel/Charts/Dynamics.html The entry below might help with setting a dynamic Y axis via code . . . http://www.pdbook.com/index.php/excel/tie_y_axes/ "Stan Altshuller" wrote: Hi all, two questions: 1. I have a scatter plot of returns and I want to add not a trend line but simply x=y line to my plot (and other equations) Any way to do this? 2. I need to control both my x and y axis, I want to max and min and scale numbers to be linked to a cell in my spreadsheet instead of simply being static values or auto. THANKS! Stan |
#3
|
|||
|
|||
Maybe this idea will help.
Private Sub Chart_Activate() ActiveChart.Axes(xlValue).Select With ActiveChart.Axes(xlValue) .MinimumScale = RANGE("B4")'bottom .MaximumScale = RANGE("B5")'Top .MinorUnitIsAuto = True .MajorUnitIsAuto = True ' .MajorUnit = 500 .Crosses = xlAutomatic .ReversePlotOrder = False .ScaleType = xlLinear .DisplayUnit = xlNone End With ActiveChart.Deselect Application.ScreenUpdating = True End Sub -- Don Guillett SalesAid Software "Stan Altshuller" wrote in message ... Hi all, two questions: 1. I have a scatter plot of returns and I want to add not a trend line but simply x=y line to my plot (and other equations) Any way to do this? 2. I need to control both my x and y axis, I want to max and min and scale numbers to be linked to a cell in my spreadsheet instead of simply being static values or auto. THANKS! Stan |
#4
|
|||
|
|||
Stan -
1. Plot a formula You could put some X values into a column, use the formula to compute Y values in the next column, then copy this range, select the chart, use Paste Special from the Edit menu to add a new series, with categories in the first column. Here are some fancier examples that bypass the worksheet: http://oaltd.co.uk/DLCount/DLCount.a...e=ChtFrmla.zip http://tushar-mehta.com/excel/softwa...ger/index.html 2. Linking axis parameters to cells How to: http://peltiertech.com/Excel/Charts/...nkToSheet.html Add-in that does it for you: http://tushar-mehta.com/excel/softwa...art/index.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Stan Altshuller wrote: Hi all, two questions: 1. I have a scatter plot of returns and I want to add not a trend line but simply x=y line to my plot (and other equations) Any way to do this? 2. I need to control both my x and y axis, I want to max and min and scale numbers to be linked to a cell in my spreadsheet instead of simply being static values or auto. THANKS! Stan |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
set up the x and y axis range in line graph in Visio? | VishnuK | Visio | 1 | November 11th, 2004 08:10 AM |
Creating a Line Chart with double Y Axis | parker_yuan | Charts and Charting | 1 | August 8th, 2004 02:28 PM |
Chart series split over more than 1 line - dont plot #n/a | allycat898 | Charts and Charting | 2 | March 22nd, 2004 10:11 AM |
Plot Line in data table | Daniel Chalmers | Charts and Charting | 4 | September 24th, 2003 07:48 PM |