Changing a bar chart

In a standard bar chart, with say 5 yrs of data, I wish to make the 2006 bar
a stacked bar with the lower part the ytd and the upper part of the bar the
estimated year end. Pls help.

--
\\\|///
\\ ~ ~ //
( @ @ )
--oOOo-(_)-oOOo---
Charlie Woll

You could enter the data in two rows, then create a stacked column chart
from all the data. For example:

2002 2003 2004 2005 2006
YTD 50 55 60 65 30
Est 40


Charles Woll wrote:
> In a standard bar chart, with say 5 yrs of data, I wish to make the 2006 bar
> a stacked bar with the lower part the ytd and the upper part of the bar the
> estimated year end. Pls help.
>


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html