| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Source data values for chart to involve a calculation
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Source data values for chart to involve a calculation
Sorry for the repost. The first one did post!
|
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pie chart & column chart w/same source data | Charts and Charting in Excel | |||
| Excel chart source data y-values can only accept 7 data pts? | Charts and Charting in Excel | |||
| Use detailed data in one worksheet to create summary data as chart source | Charts and Charting in Excel | |||
| How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
| Update a chart immediately after inputting data into data source | Charts and Charting in Excel | |||
Linear Mode
