Thread
:
Source data values for chart to involve a calculation
View Single Post
#
3
Posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
Posts: 6,582
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
Reply With Quote
Jon Peltier
View Public Profile
Find all posts by Jon Peltier