Highlight

[thong127]

Hello Gurus,

I have a data below, I want to highlight a certain point (3/17/14 8:35 PM 25.17) on my graph.
How can I do this? any help is appreciated.

Thank you so much.

Time Temperature
3/17/14 8:00 PM 25.22
3/17/14 8:05 PM 25.22
3/17/14 8:10 PM 25.22
3/17/14 8:15 PM 25.22
3/17/14 8:20 PM 25.22
3/17/14 8:25 PM 25.22
3/17/14 8:30 PM 25.17
]3/17/14 8:35 PM 25.17
3/17/14 8:40 PM 25.17
3/17/14 8:45 PM 25.17
3/17/14 8:50 PM 25.17
3/17/14 8:55 PM 25.17
3/17/14 9:00 PM 25.17

[RobertMika]

This is Dynamic data range or one off?
You can change color on the graph for this particular point.

[thong127]

Hi Robert,

Thanks for the reply. my graph is plane line graph.

Thanks.

[RobertMika]

Ok but will this point change in time?(move to another cell) or it will stay there permanently?

[thong127]

Hi Robert,

It will stay permanently.

Thank you.

[RobertMika]

Book1.xlsx
Does this help?

[thong127]

Hi Robert,

Thank you so much. how did you do it?

Thanks.

[RobertMika]

You can choose color for each point in the line individually.
Just left click with the mouse and the you can use Color Pallet from Home tab.

[thong127]

Hi Robert,

Forgive me, I would appreciate if you can tell me step by step, coz Im trying but the color of all the points on the line are changing by the color that I will choose.

Thanks

[thong127]

Im using excel 2010

[RobertMika]

Please see your PM first.

[thong127]

Hi Robert,

I got your PM.

[RobertMika]

When you first time click the line it will choose all points.
Try to click again pointing to one point only- this need some practice but finally you will choose only one point.
The you can color it with the color you have choosen

[thong127]

Thank you so much Robert,

It works like a charm! two thumbs up for you!!