Sectioning a single plotted line into multiple colors

Hi, I'm trying to plot a column of data values and I need to designat
certain sections of this data with a different color on the line. I
this possible? How can I do this? Thanks

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Suppose your data are in A1:A20 and you want A11:A20 to be a different
color from the first part of the range.

Move A11:A20 to B11:B20. Plot A1:B20 as two columnar series.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <fish.x5vqa@excelforum-nospam.com>, fish.x5vqa@excelforum-
nospam.com says...
>
> Hi, I'm trying to plot a column of data values and I need to designate
> certain sections of this data with a different color on the line. Is
> this possible? How can I do this? Thanks.
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>
>