software

Hi.

I have a line chart and I'd like to somehow indicate every third point
with a different color or something. Is there a way to do this?

Thanks.--
elbows
------------------------------------------------------------------------
elbows's Profile: www.excelforum.com/member.php...foamp;userid=7449
View this thread: www.excelforum.com/showthread...hreadid=521755Hi,

Let's suppose that the x-values(Category axis) and the y-values are in say
A2:A101, and B2:B101 respectively, and also that you have already created a
Line Plot with B2:B101 vs A2:A101.

In C2 enter, =B2

Now select C2:C4 (note that C3 and C4 are blank), move the cursor to the
bottom-right corner of the selected area (the cursor-icon will turn into a
' ' symbol), hold the left mouse-button, and drag down to C101. This action
will copy every third y-value into Column C.

Now add a series to your Line Plot, with C2:C101 vs A2:A101. Format the
second series as you wish to distinguish it from Series 1.

Regards,
B. R. Ramachandran

quot;elbowsquot; wrote:

gt;
gt; Hi.
gt;
gt; I have a line chart and I'd like to somehow indicate every third point
gt; with a different color or something. Is there a way to do this?
gt;
gt; Thanks.
gt;
gt;
gt; --
gt; elbows
gt; ------------------------------------------------------------------------
gt; elbows's Profile: www.excelforum.com/member.php...foamp;userid=7449
gt; View this thread: www.excelforum.com/showthread...hreadid=521755
gt;
gt;


That was a good idea. Thanks!--
elbows
------------------------------------------------------------------------
elbows's Profile: www.excelforum.com/member.php...foamp;userid=7449
View this thread: www.excelforum.com/showthread...hreadid=521755