+ Reply to Thread
Results 1 to 4 of 4

Combo Charts

  1. #1
    Dmorri254
    Guest

    Combo Charts

    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

  2. #2
    Michael Malinsky
    Guest

    Re: 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" <[email protected]> wrote in message
    news:[email protected]...
    > 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




  3. #3
    Dmorri254
    Guest

    Re: Combo Charts

    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" <[email protected]> wrote in message
    > news:[email protected]...
    > > 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

    >
    >
    >


  4. #4
    Dmorri254
    Guest

    Re: Combo Charts

    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" <[email protected]> wrote in message
    > news:[email protected]...
    > > 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

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1