Excel VBA Introduction Part 50.4 - Highlighting Min and Max Values in a Chart

Опубликовано: 09 Сентябрь 2024
на канале: WiseOwlTutorials

By Andrew Gould

- In this video you'll learn how to highlight the minimum and maximum values in a chart using VBA. You'll learn how to loop over the series collection of a chart, capture the array of values associated with the series and calculate the minimum and maximum values using worksheet functions. You'll also learn how to loop over the array of values and apply formatting to the data points which match the maximum and minimum values. In the final part of the video you'll see how to apply the same techniques to a line chart, including how to display markers on the lines.

You can download the completed file here

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link to make a donation. Thanks for watching!

You can buy our Introduction to Excel VBA book here

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C Visual Basic, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio and more