Holiday date to be red in horizontal axis

[sumonrezadu]

Our holiday in the month of Feb, 2016 includes all Friday and 21st February. So I want date 5-Feb,12-Feb,19-Feb,21-Feb & 26-Feb text to be in bold red color in horizontal axis in graph like their value zero.

Is there anyone to help. Thanks in advance.

Regards

Rezaul

[sktneer]

See if the attached does what you were trying to achieve.

Here are the steps required:

1) Insert a sheet and name it Holidays.
2) Add two helper columns and place the formula shown on the Trend sheet.
3) Add two more series to the chart.
4) Hide the primary horizontal axis.
5) Show data labels for both the new series with label position Below.
6) Format the data labels for both the series and uncheck Value and select Category Name instead.
7) Format the data labels for Holiday series and set the Red color for data labels.
8) You may adjust the range used in the formulas and list all the holidays on Holidays Sheet.

[sumonrezadu]

Thanks a lot Mr. Sktneer. My problem is nicely solved. I'm really grateful to you.

[sktneer]

You're welcome. Glad I could help.