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
 

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.

Ask a Question

Similar Threads

chart source data 1
Gantt chart duration not showing 0
Excel 2007 charts: want to avoid zero values 1
Split form 0
Excel 2010 - Line Chart with Mulitiple Data Sets 1
Drop down list control value in vba 2
One extra x axis item that wont go away - can anyone help? 3
how to copy XY charts into new worksheet? 1

Top