Adding Incremental Data to a Column Graph

[sdcards]

I'm Guessing that this may have been asked before, but could not find anything. If it has been answered, I would gladly review that information if someone wants to point me in that direction.

Anyway, I have a column graph that shows company totals on the left, in three columns, and sub-group totals to the right.
These columns represent Revenue Targets (Blue), and current projections (Red) as of the current time. Ignore the green column.
I would like to add incremental amounts to the Red column weekly, as the projections change. So I want to show an increment on top of the red column.

So if LG picks up 100 of additional revenue, I want to show the increment of 100 on top of the 2000 that is there, using a different pattern or cross-hatch.

I have attached a file to show what I have at this point.

I hope my question is clear.

Thanks,

SDWklyMktgWins.xls

[Andy Pope]

add 3 more series and move the main data to the secondary axis so it appear infront of the shaded series.

[sdcards]

Thank you Andy.
Two additional questions.
1) How did you create the secondary axis (I really am a novice), and
2) If I wanted to add an increment each week for the next 4 weeks, would I keep adding series?

Thanks,


SD

[Andy Pope]

Select the series and then via the Format dialog select Secondary axis. repeat for other series.

If you wanted to show each week as a different section then you would require more series. But more importantly you would need to chart the chart type to stacked column.
Otherwise simply increase the value of the additional series by summing more values.