Pie chart source data
 

The "Source Data" menu item is greyed out for my pie chart. Is there any way
to confirm the source of the data that is driving the pie chart? I would
rahter not utilize a "trial-and-error" method.

Thanks

Pie chart source data
 

Select the chart and click on one of the wedges. In the formula bar (above
the column labels), there is a formula which tells where the data came from.
It looks like this:

=SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$6,Sheet1!$B$2:$ B$6,1)

where the four arguments refer to the series name, the X values (category
labels), the Y values, and the plot order.

More on the series formula:

http://peltiertech.com/Excel/ChartsH...esFormula.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"ralphmhqa" wrote in message
...
The "Source Data" menu item is greyed out for my pie chart. Is there any
way
to confirm the source of the data that is driving the pie chart? I would
rahter not utilize a "trial-and-error" method.

Thanks