Thank you very much...will try this..

David

"Michael Malinsky" wrote:

> If you add a column that calculates the change and make that part of the
> data series, then you can put the change data on the secondary axis as
> follows:
>
> Select the "change" series then go to the properties for that series. Under
> the Axis tab, select Secondary axis. This will give you bars for the change
> data and will show the change data along the right of the chart (assuming
> you are using a vertical bar chart). With the change series still selected,
> click on the "chart type" button on the chart toolbar and select the type of
> chart you want for the change data, for example, selecting a line chart will
> show a line for the change series superimposed over the bar chart.
>
> I hope I explained this well enough for you.
> "Dmorri254" <Dmorri254@discussions.microsoft.com> wrote in message
> news:276DE362-0842-4149-ABD8-AC0FD9A3C03E@microsoft.com...
> > Hello,
> >
> > I have a column chart with a trend line that depicts the amount of
> incidents
> > that occur month to month for example Nov 470 Dec 420 ...What I would
> like
> > to do is on the same chart, show the percent of increase or decrease
> between
> > the months to give more substance to the chart...has anyone done this
> before?
> >
> > Thanx
> >
> > David
>
>
>