Often, people want to enter a formula in some magical place, and have the chart
display it. Bernard's suggestion is to put the X values you want in one column of a
worksheet, calculate the corresponding Y values in the adjacent column, and chart
this data. Don't be afraid to use the worksheet, that's why Excel has one.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions http://PeltierTech.com/
_______
Tushar Mehta www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.