Highlight specific cells in an excel chart

galmond1010

New Member
Joined
Apr 15, 2019
Messages
21
Is it possible to highlight a specific column in an excel chart? I have several months of data and I only want to highlight ytd.

This is the data listed below the bar chart

Sep-18 Oct-18 Nov-18 Dec-18 YTD
10.8% 9.3% 4.4% 11.2% 8.7%


Thank you
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

DataBlake

Well-known Member
Joined
Jan 26, 2015
Messages
779
Office Version
2016
Platform
Windows
Is it possible to highlight a specific column in an excel chart? I have several months of data and I only want to highlight ytd.

This is the data listed below the bar chart

Sep-18 Oct-18 Nov-18 Dec-18 YTD
10.8% 9.3% 4.4% 11.2% 8.7%


Thank you
What kind of chart?
are you saying you want to create form controls where you click a cell and it highlights that info on a chart?
check this out and see if its whats you're looking for:
https://www.get-digital-help.com/2013/01/29/highlight-a-column-in-a-stacked-column-chart/
 

galmond1010

New Member
Joined
Apr 15, 2019
Messages
21
Thank you for the information. I created a simple excel bar chart with data listed below, months and percent. The format data table can highlight entire rows or columns. I would like to highlight only the YTD column. Is this possible?
Thank you.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,367
Messages
5,468,210
Members
406,571
Latest member
carrie1994

This Week's Hot Topics

Top