Excel How To Use Vba To Make Charts - Episode 1211.211
Microsoft Excel Tutorial: Controlling Chart Location using VBA Macro.
Welcome back to the MrExcel netcast! In this episode, we're diving into Chapter 11 of our VBA Macros book, all about charting macros. Specifically, we'll be discussing how to control the exact location of a chart using VBA.
To start off, I'll show you a quick macro that creates a default chart using the Add Chart method. However, the problem with this method is that it uses the Top, Left, Width, and Height properties, which can be risky if someone adjusts the columns or rows in the spreadsheet. That's why I'll be showing you a safer and more efficient way to control the chart location.
In Module 3, I've rewritten the code to use the range of cells instead of the pixel measurements. This means that the chart will always be placed in the same location, no matter how the spreadsheet is adjusted. For example, instead of saying the chart should be 100 pixels from the left edge, we'll use the range E5 and let Excel determine the exact location based on that cell.
This method not only ensures the chart is always in the correct location, but it also allows for more flexibility in case the spreadsheet is adjusted. So, if someone makes Column C wider or Row 9 taller, the chart will still appear in the correct location. This is a much safer and more efficient way to control the chart location using VBA.
I hope you found this tip helpful and will use it in your own VBA projects. Don't forget to check out our sponsor, MrExcel.com, for all your Excel needs. And as always, thank you for tuning in to the MrExcel netcast. See you next time for more VBA tips and tricks!
Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...
Table of Contents
(00:00) Choose Location When Creating a Chart with VBA
(00:29) Record a chart macro
(00:51) Using AddChart method in VBA
(01:15) Specify Top, Left, Width and Height
(01:27) Need number of pixels
(02:12) Find the Left and Top of a particular cell
(02:54) Success - chart lines up with cell
(03:17) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelvba #charts #excelcharts #excelchartstutorial
This video answers these common search terms:
how to copy a chart in excel vba
using vba to make chart in excel
set exact chart location using VBA
using vba to make graph in excel
how to make graph excel macro
how to generate graph in excel with macros
how to create an excel graph macro
how to use macros in excel to graph
how to create a macro to create graph in excel
how to create a chart in excel using macro
excel vba chart examples
vba code for creating excel graphs
dynamic chart with vba excel
excel vba plot chart data
tutorial on vba excel charting
automated chart creation with vba
excel macro for creating charts
vba excel graphing tips
how to use vba to make charts
excel vba charting basics
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
Chapter 11 takes a look at many charting tricks. This podcast shows you a cool way to make sure that your charts appear in an exact cell range.
Watch video Excel How To Use Vba To Make Charts - Episode 1211.211 online without registration, duration hours minute second in high quality. This video was added by user MrExcel.com 15 July 2010, don't forget to share it with your friends and acquaintances, it has been viewed on our site 9,013 once and liked it 43 people.