Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line of Initial Rate
How do I do a Line of Initial Rate on a chart?
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line of Initial Rate
First of all, use an XY chart, not a Line chart.
In algebra we learned that the equation of a line is Y=mX+b. m is your initial slope, b is the value of Y where X is zero. If you planned it so the phenomenon you're monitoring starts at (0,0), then b is zero, so you need to plot a series with two points, (0,0) and (Y,X), where Y=mX. pick an appropriate value for X so the line stays in the chart. Put the data into the sheet like this: 0 0 X Y <-- your calculated values Copy this range, select the chart, and use Paste Special to add the data as a new line, with series in columns and category labels (X values) in the first column. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jeni" wrote in message ... How do I do a Line of Initial Rate on a chart? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Table w/straight-line depreciation & annual rate depreciation for. | Excel Worksheet Functions | |||
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
Prime rate/Liber rate into sheet automatically? | Excel Discussion (Misc queries) | |||
Real RATE of return using =RATE illusive, inflation adjusted inflo | Excel Worksheet Functions | |||
Remove middle initial from "first name middle initial" | Excel Discussion (Misc queries) |