Forum Discussion
How do I change color of data plot line
So a) yes it is possible to selectively color segments of a line different colors. You can use VBA or manually you can click on the line (entire series is selected) then click on a it again and the nearest data point is selected. Right click and select 'Format data point'. Then click the paint bucket and under the 'Line' section change the color. You can then repeat for every data point/line segment you want to change. You can also use CTRL-arrow key to move point to point on the line.
That said, that is a lot of work and @Rine_van_Eekelen method is much easier. 1 tip to make it easier is that you can keep you existing columns and just copy the data UP TO 06-30 into a new column. Then add that new column as a new line on the graph and it can sit 'on top' of the existing line. In this way you can maintain the full column of data you have.here is the previous example updated this way:
So the second column "Orig data" just needs to be copied once since it won't change.
I also show how I could change an individual segment inside the blue line to green.
Seeker336 I believe you need to have separate series for "before" and "after" with an over lap for the last and first date. An example is attached.
Riny_van_Eekelen Thansk for your response. Seems so simple, but I tried to create an additional column to record data after 1 July, entered string of test values, and cannot get any of them to post.
When I try to go to Select Data and create a new Series, the dialog box gives me an error saying I appear to be creating a formula that Excel cannot execute. I guess I don't understand enough about how to create a series -- apparently missing something in the syntax, although I have been trying to duplicate the existing series and simply replace references to the new series of cells.
Totally confused.