how do i make an xy graph start at 0 instead of at 1?
I made a scatter graph, with the origin value at 0. when i made a line of
best fit, the line starts and 1. how do i make it start at 0?? |
how do i make an xy graph start at 0 instead of at 1?
I will assume that "made a line of best fit" means you added a
trendline. If so, double-click the trendline. In the resulting dialog box, from the Options tab, check 'Set Intercept to' and enter zero in the adjacent textbox. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I made a scatter graph, with the origin value at 0. when i made a line of best fit, the line starts and 1. how do i make it start at 0?? |
how do i make an xy graph start at 0 instead of at 1?
If your first X value is at 1, double click the trendline, and on the
Options tab, in the Forecast box, change backwards to 1. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "NeoDS" wrote in message ... I made a scatter graph, with the origin value at 0. when i made a line of best fit, the line starts and 1. how do i make it start at 0?? |
how do i make an xy graph start at 0 instead of at 1?
When you add the trendline, specify intercept at 0
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "NeoDS" wrote in message ... I made a scatter graph, with the origin value at 0. when i made a line of best fit, the line starts and 1. how do i make it start at 0?? |
how do i make an xy graph start at 0 instead of at 1?
thank you for you help, but i need the trend line to be a cuve, and when i do
that it won't let me to set the intercept. "NeoDS" wrote: I made a scatter graph, with the origin value at 0. when i made a line of best fit, the line starts and 1. how do i make it start at 0?? |
how do i make an xy graph start at 0 instead of at 1?
thank you for you help, but i need the trend line to be a curve, and when i
do that it won't let me to set the intercept. "NeoDS" wrote: I made a scatter graph, with the origin value at 0. when i made a line of best fit, the line starts and 1. how do i make it start at 0?? |
how do i make an xy graph start at 0 instead of at 1?
What form of curve do you need for your trendline? -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=496608 |
All times are GMT +1. The time now is 10:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com