Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Thanked 0 Times in 0 Posts

    Line Column Chart with Stacked Columns (2002 SP3)


    I've had help here before with putting a trend line on a stacked column chart (using an array), now I need to know how to how to put a line on a stacked column chart.
    I have 3 sets of data
    Actual Claims (actual claims received) , Projected Claims (my projections based on the past 12 months activities- changes each month)
    Target Claims (fixed numbers for each year)

    I want to stack the actual and projected claims so that previous years will only show actual, the current year will show actual and projected and future years will show just projected.

    Next I want to have a line that shows existing targets, and by looking at the chart, you can tell in any given year whether the claims are over or under the target.

    I can get a line-column chart however the current year shows the actual and projected side by side rather than stacked, and therefore does not properly show how the current year is faring in relation to the target.

    I am presuming Excel does not allow what I am requesting and was wondering if anyone knows a work around to achieve the desired results.

    Thanks for any assistance.


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Line Column Chart with Stacked Columns (2002 SP3)

    It's possible, but I don't think it's a good idea. It's difficult to handle both a projection higher than actual and a projection lower than actual. Why don't you use a line chart (with three lines)?

Posting Permissions

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