Archive of Mr Excel Message Board
Check out Bill's new book on Charts and
Graphs for Microsoft Office Excel 2007
Back to Charting for Excel archive index
Back to archive home
need 3d surface charts with red=$ loss, green= $profitPosted by David on March 24, 2001 1:49 AM
I'm developing several charts for a financial modeling program and can't find a way to get my charts to graph in two colors. The legend always comes up with at least 3 or more colors. I have the same problems in both the 2 dimensional surface charts as well as the three dimensional surface charts.
I need these charts to show the loss area of the graph in red and the profit area in green.
The data source is about a 20 cell by 20 cell area that sums up 5 other similar areas. The values are dynamic so the amount of proportion of profitable area vs. loss area can change dramatically from chart to chart.
Any books, websites, or programming examples would be greatly appreciated. (I have five excell books in my office and can't find anything to do this.)
Re: need 3d surface charts with red=$ loss, green= $profit - area chart instead?Posted by mseyf on March 24, 2001 5:16 PM
I don't fully understand what you're trying to do, but my initial impression is that an area chart may be what you're looking for
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.