Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi!
I want to display a bargraph including a trendline on the Internet (using an asp-page). It doesn't matter what I use to display it. I have found some graph-components (for example FusionCharts 2.2) that seems ok. First: What is the easiest way to go? 1. Calculate the trendline values (with vbscript or javascript) and using a graphcomponent 2. or using a excelcomponent and somehow manipulate it to show the graphs (bargraph and trendline) that I want. IF 1: Then the problem I have is that I can not figure out how to calculate the trendline values. I have found a page (http://www.j-walk.com/ss/excel/tips/tip101.htm) that has some code used in Excel (see below). But the INDEX, LINEST functions doesn't work in vbscript. __________________________________________________ ____ Logarithmic Trendline Equation: y = (c * LN(x)) - b c: =INDEX(LINEST(y,LN(x)),1) b: =INDEX(LINEST(y,LN(x)),1,2) Power Trendline Equation: y=c*x^b c: =EXP(INDEX(LINEST(LN(y),LN(x),,),1,2)) b: =INDEX(LINEST(LN(y),LN(x),,),1) __________________________________________________ ____ IF 2: I am not very used to excel-programming so how can I do this trendline using a component? Oh, the person that will see this graph does not have the excel program. Best regards, Mattias in Sweden |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel | |||
Fonts get size 1 and can't be changed after a procedure - even by excel GUI!! | Charts and Charting in Excel | |||
Excel 2003 | Charts and Charting in Excel | |||
Trendline error??? | Charts and Charting in Excel |