Source data values for chart to involve a calculation

  • Thread starter Thread starter Sridhar S
  • Start date Start date
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
 
No, you have to do the calculation in the worksheet, then plot the cells
containing the calculations.

- Jon
 
Back
Top