If the active chart is not a Radar chart, the shape will not be correctly drawn, and the procedure may crash before drawing any shape. The VBA code could be adjusted to produce shapes of any desired color scheme, but it may be just as easy for most cases to run the macro, then double click on the shape to open the formatting dialog. google_ad_slot = "3653883320"; It is useful when analyzing results from a survey, compare target vs actual values, performance review, etc.. Hope this will help you. Plotted points, labels, and other elements will be obscured by the shapes. When I put in the area data, it does not go under the scatter line in goes under the curve and also now displays the wrong access data. On the Design tab, in the Chart Styles group, click the chart style that you want to use. Peltier Technical Services, Inc., Copyright © 2017. Excel can recommend charts for you. The VBA procedures below do not have any error-checking built into them. These procedures draw polygonal shapes, using each point in the series as a node. As in Radar chart, Filled Radar chart shows values relative to a center point. In a Filled Radar chart, the area covered by a data series is filled with a color. That is all. Chnage the axis color -> Properties -> Axes -> Change the Axis color. //-->. When you insert a scatter chart in Excel, if the data is closer, some markers may be hidden as below screenshot shown. 1 to 10), radar chart is probably not the best chart to represent these data. Line and Fill Effects in Excel Charts Using VBA. In this case, the existing shapes must be deleted and redrawn. Line and Fill Effects in Excel Charts Using VBA shows how to draw shapes on an XY chart to produce these formats, using the polygon drawing tool. Below will be your cheat sheet for manipulating Excel charts & graphs with VBA code. This video shows you how to create Filled Radar Chart in MS Excel 2013.Excel Tips \u0026 Tricks : https://www.youtube.com/playlist?list=PLZnHzQfaP-kM1-Vfhd_h19jTKbYEuGgD-Excel Analysis : https://www.youtube.com/playlist?list=PLZnHzQfaP-kOY6XVgxq5KX94m9dvCp4I5Excel Functions : https://www.youtube.com/playlist?list=PLZnHzQfaP-kOV5sfQqKEHg4gD_88FPcfLExcel DAX formulas : https://www.youtube.com/playlist?list=PLZnHzQfaP-kPri8SUozzLqA6ZEF77-UVxExcel for Job Interview : https://www.youtube.com/playlist?list=PLZnHzQfaP-kNz4N7gdDwbw1-xelRiqNs8Excel 365 Features : https://www.youtube.com/playlist?list=PLZnHzQfaP-kP73WZ1j2r5eelCQv1nM8FnExcel 2019 Features : https://www.youtube.com/playlist?list=PLZnHzQfaP-kNjDGlDUe7102SgVA2bNLHnMobile Excel Tutorial : https://www.youtube.com/playlist?list=PLZnHzQfaP-kPmQqjUzquKKqk-iwCi7tapCreative \u0026 Advanced charts : https://www.youtube.com/playlist?list=PLZnHzQfaP-kOnddZhSPMWRbhv2pbL0CO2Excel Automation : https://www.youtube.com/playlist?list=PLZnHzQfaP-kP5pB7IrO6DSg8-bNLFNY7_450 Excel functions with examples : https://youtu.be/hY23hntm7nU50+ Important excel functions with examples : https://youtu.be/E2JDZKNVv4QTop 60 widely using most popular excel functions : https://youtu.be/YJnviIv3VA0Different types of MIS reports \u0026 dashboard creation : https://youtu.be/NaJws5q5Jf4HR MIS dashboard using Power Pivot : https://youtu.be/bmkBW0VUe2o#excel#learnexcel#exceltutorial#microsoftexcel#microsoftexceltutorial#msexcel#excelhelp#ExcelSpreadsheets#SpreadsheetHelp #Spreadsheet#excelexperts#ExcelSpecialists#excelsupport#excelgraphs#excelchartThank you for watching this video ! Example: Create a Shaded Line Chart for Site Visit. To create an area chart in Excel…