View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Rowan Drummond Rowan Drummond is offline
external usenet poster
 
Posts: 11
Default Stacked Column Chart / Normal Column Chart

Hi All

I have 3 numbers: Sales so far this week, projected sales for the rest of
the week and weekly target.

I want to have a column chart with two columns.
The first column is a stack of the sales so far this week and the projected
sales for the rest of the week which would show Total projected sales for the
week.
The second column is a normal column showing just the weekly target.

I can't work out how to combine the stacked chart with the normal column
chart. Any help would be greatly appreciated.

Many thanks
Rowan