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
Change the chart backgroung or curve colour
Posted by Florin Stoiean on September 19, 2001 12:01 AM
Dear Sir,
Could you tell me if it's possible to change the chart curve color when it pass a known high or low limit. Or,how can I split the chart background in intervals colored in different ways?
Thanks.
Florin
Re: Change the chart backgroung or curve colour
Posted by Chris on September 19, 2001 1:36 AM
You can do this manually by selecting the line on the chart (data series). Then select the data point on that data series (by single clicking on the line or bar etc.) Then select format data point and you should know the rest.
Use a combination chart as described here...
Posted by Mark W. on September 19, 2001 7:00 AM
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.