Hello. If I have a line chart with dates, how can I make different years, different colors?
Hello. If I have a line chart with dates, how can I make different years, different colors?
Hello Amma,
Go to your line chart, click on line then click again on line, a particular year will be selected now and now you can format accordingly.
Line Chart Color.PNG
Thanks,
Anil Dhawan
Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.
Don't stop when you are tired. STOP when you are done!
If you face any problem, follow the below steps.
Select On line of the chart. (See Below).
Chart Line Color 1.png
Then try to select particular any year by doing another click (See as I have selected 2019)
Chart Line Color 2.png
Do right click now, and go to Outline to change the color of the line.
Chart Line Color 3.png
Here you go, You are now done. (I am also done as i have changed the 2019 year line to Red).
Chart Line Color 4.png
Hope this will make you more clear.
Cheers!!!
Anil
depending on the criteria for line colour you could just use the "Vary colors by point" option.
Format line, Marker fill, Vary colors by point.
Note you do not need to have a marker displayed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks