Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel trendline label error
if i plot the following data
1 100,000 2 200,000 3 300,000 4 400,000 etc as a scatter graph and draw a linear trendline through it. the equation tells me the line is y = 10,000 x when it should be y = 100,000x . If i format the label and choose any format under number OTHER than general, i get the right answer, even choosing "TEXT as the format gives me the right answer, but the default formatting for the number is "General" and it wont give the right equation if the coefficient has more than 5 digits any suggestions? i know i can go and change the format on each graph i draw but id like the default format give me the right answer straight away, or be able to change which format is default thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel trendline label error
mark -
I can replicate this bug in Excel 2007. Suggestion: Wait for Office 2007 Service Pack 1. Maybe it will be fixed. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "mark" wrote in message ... if i plot the following data 1 100,000 2 200,000 3 300,000 4 400,000 etc as a scatter graph and draw a linear trendline through it. the equation tells me the line is y = 10,000 x when it should be y = 100,000x . If i format the label and choose any format under number OTHER than general, i get the right answer, even choosing "TEXT as the format gives me the right answer, but the default formatting for the number is "General" and it wont give the right equation if the coefficient has more than 5 digits any suggestions? i know i can go and change the format on each graph i draw but id like the default format give me the right answer straight away, or be able to change which format is default thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel trendline label error
thanks for the reply Mike,
i guess waiting for SP1 is the only answer. bit worrying though when you cant trust the equation. mark "Mike Middleton" wrote: mark - I can replicate this bug in Excel 2007. Suggestion: Wait for Office 2007 Service Pack 1. Maybe it will be fixed. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "mark" wrote in message ... if i plot the following data 1 100,000 2 200,000 3 300,000 4 400,000 etc as a scatter graph and draw a linear trendline through it. the equation tells me the line is y = 10,000 x when it should be y = 100,000x . If i format the label and choose any format under number OTHER than general, i get the right answer, even choosing "TEXT as the format gives me the right answer, but the default formatting for the number is "General" and it wont give the right equation if the coefficient has more than 5 digits any suggestions? i know i can go and change the format on each graph i draw but id like the default format give me the right answer straight away, or be able to change which format is default thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trendline error | Charts and Charting in Excel | |||
Trendline Equation error Excel 2007? | Charts and Charting in Excel | |||
How do I edit label when cursor is placed on trendline in excel? | Charts and Charting in Excel | |||
trendline error | Charts and Charting in Excel | |||
Trendline error??? | Charts and Charting in Excel |