Forum Discussion
How to highlight specific data in dynamic charts.
How do I highlight specific data in a various dynamic charts. I am trying to highlight in this case the maximum and minimum data in my dynamic charts. Attached is a copy of my excel.
8 Replies
Liphor Just add the Minimum and Maximum as separate series. Make sure that the empty data points become #N/A by using NA() it the IF formula, rather than " ". Set the series overlap to 100% and reduce the gap width for the extra series slightly and colour each series to your liking.
See attached.
Thank you for your solution. However I realized that there is blank space in the charts that has fewer datas. I tried using countif and named range but not successful. How do I overcome this? Attached is the spreadsheet of what I have done.
Liphor You can do that by declaring dynamic chart ranges. I've done that in the attached workbook. More information in the attached link.
