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
Bookmarks