Thanks for the help. I have been using the helper column, it just seemed
like I was adding more work. I thought maybe I was missing an easier step.
Thanks again.
--
Shirley


"Andy Pope" wrote:

> Hi,
>
> The simplest way is to use a helper column and formula to alter your
> data and then chart that. You can not directly apply formula to the data
> series within the chart.
>
> Cheers
> Andy
>
> Shirley wrote:
> > I am referencing a column of data into a chart. How do I perform an
> > operation on the data before it is entered into the chart? For example, I
> > want the row of data to be divided by 1000, and then charted.
> > HELP! This is driving me crazy!
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>