View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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