Re: Mixed Chart Formats

If you stagger your data, you can create side-by-side stacked columns.
For example:

Jan Feb

Type1 100 120
Type2 50 60
Type3 90 100

CurrVal 40 50

Bernard Liengme has an example and instructions on his site:
http://www.stfx.ca/people/bliengme/...ips/Columns.htm

and the following MSKB article has an example:
XL2000: Creating Charts with Multiple Groups of Stacked Bars
http://support.microsoft.com/default.aspx?id=214119


Martin M wrote:
> I need to make a chart that has 3 columns of data stacked
> into one bar and a 4th column shown beside it. The three
> columns are investment information and the 4th is the
> current value and I need to show the graph so that people
> can see the difference in the investment by type vs
> current worth.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html