User Profile
Seeker336
Copper Contributor
Joined Jul 14, 2022
User Widgets
Recent Discussions
Re: How do I change color of data plot line
Thanks. I am certainly a novice and even had trouble with the "original column" approach, but finally got it to work. Some miracle elf must have taken pity on me and swooped inside my computer -- took me about four tries to get the original line to superimpose in another color. Thanks for your help.7.9KViews1like0CommentsRe: How do I change color of data plot line
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.8.1KViews0likes0CommentsHow do I change color of data plot line
I need some help modifying the plot line on a line chart. I am in Excel 2016 as a part of an Office 365 subscription. I have a spreadsheet I use to record daily body weight measurements. Column A is the date, plotted on the horizontal axis of a line chart. Column B is the daily body weight in pounds, plotted on the vertical axis of the line chart. The plot line on the chart is currently depicted in RED. I want to continue with the plot line, but have the color of the line change to BLUE as of a certain date, say 1 July, which represents the beginning of a weight loss program. I have tried to edit the Series, cutting it off as of 30 June, then creating a new Series that begins 1July and continues to the end of the year, but test data entered for dates after 1 July do not plot on the chart. Perhaps I don't understand how to edit/create a Data Series. My objective is to have a continuous line plot that simply refects a color change as of a certain date. Seems rather simple and straightforward, but I have thus far only come away confused and unsuccessful. Can anyone help with this charting issue? Thanks.Solved11KViews0likes5Comments
Recent Blog Articles
No content to show