Source data values for chart to involve a calculation
 

Can I enter a formula in the chart wizard while choosing the data values?
For example, my Y-axis is a sum of two series that the chart wizard needs to
be fed (as in a sum function or formula) and calculated on its own?

Thanks,
Sridhar

Source data values for chart to involve a calculation
 

Sorry for the repost. The first one did post!

Source data values for chart to involve a calculation
 

No, you have to do the calculation in the worksheet, then plot the cells
containing the calculations.

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


"Sridhar S" <Sridhar wrote in message
...
Can I enter a formula in the chart wizard while choosing the data values?
For example, my Y-axis is a sum of two series that the chart wizard needs
to
be fed (as in a sum function or formula) and calculated on its own?

Thanks,
Sridhar