If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Change color of every third point
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: http://www.excelforum.com/member.php...fo&userid=7449 View this thread: http://www.excelforum.com/showthread...hreadid=521755 |
#2
|
|||
|
|||
Change color of every third point
Hi,
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 "elbows" wrote: 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: http://www.excelforum.com/member.php...fo&userid=7449 View this thread: http://www.excelforum.com/showthread...hreadid=521755 |
#3
|
|||
|
|||
Change color of every third point
That was a good idea. Thanks! -- elbows ------------------------------------------------------------------------ elbows's Profile: http://www.excelforum.com/member.php...fo&userid=7449 View this thread: http://www.excelforum.com/showthread...hreadid=521755 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how do i change the shape of the insertion point? | Misha | General Discussion | 2 | November 30th, 2005 05:36 PM |
How do I change the appearance of the insertion point? | GinaH | General Discussion | 1 | November 29th, 2005 06:38 PM |
how do i change ruler from point to inches | linda and steve | General Discussion | 1 | May 30th, 2005 09:07 PM |
how do I change a power point presentation into a word document?. | Leah | Powerpoint | 2 | January 20th, 2005 10:06 PM |
Allow user to change default pointer option in Power Point | S.J. Clark in New Hampshire | Powerpoint | 1 | September 1st, 2004 10:16 PM |