Changing a bar chart

[Charles Woll]

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

 

[Debra Dalgleish]

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