Pie chart source data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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/ChartsHowTo/ChartSeriesFormula.html

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