MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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.

Posted by Mark W. on September 19, 2001 7:00 AM

Use a combination chart as described here...