Source data values for chart to involve a calculation

S

Sridhar S

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
 
J

Jon Peltier

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

- Jon
 
Top