Combo Charts

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

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
>
>
>

One question...if the chart data is in a pivot table can I somehow add this
new info or would I have to re-create the pivot table

"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
>
>
>