Excel 2007.
Is there a way to create a chart of a polynomial function without populating
a data series?
example:
with the function Y=mx+b, can I define 'm' and 'b' and then produce a graph
showing how 'Y' changes with 'x' without creating a table of these values
first?

No.
--
David Biddulph

"fluwoebers" wrote in message
...
Excel 2007.
Is there a way to create a chart of a polynomial function without
populating
a data series?
example:
with the function Y=mx+b, can I define 'm' and 'b' and then produce a
graph
showing how 'Y' changes with 'x' without creating a table of these values
first?

Have a look Stephen Bullen's Excel Page at http://oaltd.co.uk/Excel/Default.htm
under Charting Examples he has a file ChtFrmla.zip that shows all

Other also show how to do this:
Tushar Mehta
http://tushar-mehta.com/excel/softwa...ger/index.html

Jan Karel Pieterse
http://jkp-ads.com/Articles/ChartAnEquation00.htm

best wishes

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"fluwoebers" wrote in message ...
Excel 2007.
Is there a way to create a chart of a polynomial function without populating
a data series?
example:
with the function Y=mx+b, can I define 'm' and 'b' and then produce a graph
showing how 'Y' changes with 'x' without creating a table of these values
first?

While these techniques exist, they are not easy to implement and usually are
even more difficult to debug. What's wrong with using a worksheet range?
Worksheets are cheap (in terms of memory) and valuable (in terms of what
they show you).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bernard Liengme" wrote in message
...
Have a look Stephen Bullen's Excel Page at
http://oaltd.co.uk/Excel/Default.htm
under Charting Examples he has a file ChtFrmla.zip that shows all

Other also show how to do this:
Tushar Mehta
http://tushar-mehta.com/excel/softwa...ger/index.html

Jan Karel Pieterse
http://jkp-ads.com/Articles/ChartAnEquation00.htm

best wishes

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"fluwoebers" wrote in message
...
Excel 2007.
Is there a way to create a chart of a polynomial function without
populating
a data series?
example:
with the function Y=mx+b, can I define 'm' and 'b' and then produce a
graph
showing how 'Y' changes with 'x' without creating a table of these values
first?

My views exactly but that's what OP wanted!
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Jon Peltier" wrote in message
...
While these techniques exist, they are not easy to implement and usually
are even more difficult to debug. What's wrong with using a worksheet
range? Worksheets are cheap (in terms of memory) and valuable (in terms of
what they show you).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bernard Liengme" wrote in message
...
Have a look Stephen Bullen's Excel Page at
http://oaltd.co.uk/Excel/Default.htm
under Charting Examples he has a file ChtFrmla.zip that shows all

Other also show how to do this:
Tushar Mehta
http://tushar-mehta.com/excel/softwa...ger/index.html

Jan Karel Pieterse
http://jkp-ads.com/Articles/ChartAnEquation00.htm

best wishes

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"fluwoebers" wrote in message
...
Excel 2007.
Is there a way to create a chart of a polynomial function without
populating
a data series?
example:
with the function Y=mx+b, can I define 'm' and 'b' and then produce a
graph
showing how 'Y' changes with 'x' without creating a table of these values
first?

No, that's what OP asked for (or thinks s/he wanted). Careful what you ask
for, it might be harder than you think.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bernard Liengme" wrote in message
...
My views exactly but that's what OP wanted!
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Jon Peltier" wrote in message
...
While these techniques exist, they are not easy to implement and usually
are even more difficult to debug. What's wrong with using a worksheet
range? Worksheets are cheap (in terms of memory) and valuable (in terms
of what they show you).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bernard Liengme" wrote in message
...
Have a look Stephen Bullen's Excel Page at
http://oaltd.co.uk/Excel/Default.htm
under Charting Examples he has a file ChtFrmla.zip that shows all

Other also show how to do this:
Tushar Mehta
http://tushar-mehta.com/excel/softwa...ger/index.html

Jan Karel Pieterse
http://jkp-ads.com/Articles/ChartAnEquation00.htm

best wishes

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"fluwoebers" wrote in message
...
Excel 2007.
Is there a way to create a chart of a polynomial function without
populating
a data series?
example:
with the function Y=mx+b, can I define 'm' and 'b' and then produce a
graph
showing how 'Y' changes with 'x' without creating a table of these
values
first?

I wrote the add-in, Jon, because simply listing values in a worksheet is
woefully inadequate for some functions. If one doesn't know the shape
of the function, one is left to guess as to what x-values one should
use.

Look at http://tushar-
mehta.com/excel/software/plot_manager/decompiled_help/plot6.html
particularly the subsections on comparing the results of the add-in with
other techniques.

I am also at a loss as to why you would think that entering a function
in one cell and using an add-in is either difficult to implement or
require debugging.

In article ,
says...
While these techniques exist, they are not easy to implement and usually are
even more difficult to debug. What's wrong with using a worksheet range?
Worksheets are cheap (in terms of memory) and valuable (in terms of what
they show you).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bernard Liengme" wrote in message
...
Have a look Stephen Bullen's Excel Page at
http://oaltd.co.uk/Excel/Default.htm
under Charting Examples he has a file ChtFrmla.zip that shows all

Other also show how to do this:
Tushar Mehta
http://tushar-mehta.com/excel/softwa...ger/index.html

Jan Karel Pieterse
http://jkp-ads.com/Articles/ChartAnEquation00.htm

best wishes

I've experimented with your plot manager, and would have mentioned it here,
if I'd remembered it. Obviously it would take out most of the difficulty.

I was merely thinking of the poor user who is unfamiliar with Names and
won't be able to figure out what's wrong when the chart doesn't appear as
expected.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Tushar Mehta" wrote in
message om...
I wrote the add-in, Jon, because simply listing values in a worksheet is
woefully inadequate for some functions. If one doesn't know the shape
of the function, one is left to guess as to what x-values one should
use.

Look at http://tushar-
mehta.com/excel/software/plot_manager/decompiled_help/plot6.html
particularly the subsections on comparing the results of the add-in with
other techniques.

I am also at a loss as to why you would think that entering a function
in one cell and using an add-in is either difficult to implement or
require debugging.

In article ,
says...
While these techniques exist, they are not easy to implement and usually
are
even more difficult to debug. What's wrong with using a worksheet range?
Worksheets are cheap (in terms of memory) and valuable (in terms of what
they show you).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bernard Liengme" wrote in message
...
Have a look Stephen Bullen's Excel Page at
http://oaltd.co.uk/Excel/Default.htm
under Charting Examples he has a file ChtFrmla.zip that shows all

Other also show how to do this:
Tushar Mehta
http://tushar-mehta.com/excel/softwa...ger/index.html

Jan Karel Pieterse
http://jkp-ads.com/Articles/ChartAnEquation00.htm

best wishes