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
Source Data - Values - Dynamic Range possible? 2
Using the full width of an Excel chart with two Y-axes 2
Source data - have X and Y values for 1 series 4
combining two cell values to one value to chart 4
How to embed expression in data labels on a chart 2
Time Series Chart Data Plot Line ''Disappears'' When Y Axis Formating Is Changed 8
time scale proportional using a column chart - not just for scatte 4

Top