software

The quot;Source Dataquot; 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 quot;trial-and-errorquot; method.

Thanks

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:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;ralphmhqaquot; gt; wrote in message
...
gt; The quot;Source Dataquot; menu item is greyed out for my pie chart. Is there any
gt; way
gt; to confirm the source of the data that is driving the pie chart? I would
gt; rahter not utilize a quot;trial-and-errorquot; method.
gt;
gt; Thanks