Excel Chart Data Series Help

Please advise on how to graph one line data series in different color
without changing the colors to each data point. Thanks.

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

Hi,

Have you tried the Vary colors by point option?
Select the line and press CTRL+1 to display the format dialog.
On the options tab is the Vary color checkbox.


mysteri4ever wrote:
> Please advise on how to graph one line data series in different colors
> without changing the colors to each data point. Thanks.
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>

--

Cheers
Andy

http://www.andypope.info