如何在Excel中设置图表的绝对位置？
通常，在Excel中创建或移动图表时，我们可能会随机放置图表。 但是，在某些特殊情况下，您可能希望将图表放置在精确的位置，例如从单元格A1开始，保持在范围A1：D5或其他位置。 在这里，我将介绍一个VBA来设置Excel中图表的绝对位置。
应用VBA在Excel中设置图表的绝对位置
在Excel中设置图表绝对位置的绝佳工具
应用VBA在Excel中设置图表的绝对位置
例如，您创建了一个图表并将其随机放置在工作表中，如下图所示。 现在，我将介绍一个VBA，以快速轻松地将图表移至精确且绝对的位置。
1。 选择要为其设置绝对位置的图表，然后按 其他 + F11 键以打开“ Microsoft Visual Basic应用程序”窗口。
2。 点击 插页 > 模块，然后在VBA下面粘贴到新的模块窗口中。
VBA：在Excel中设置图表的绝对位置
Sub Test()
Dim xRg As Range
Dim xChart As ChartObject
Set xRg = Range("D1:J13")
Set xChart = ActiveSheet.ChartObjects(1)
With xChart
.Top = xRg(1).Top
.Left = xRg(1).Left
.Width = xRg.Width
.Height = xRg.Height
End With
End Sub
Note: In above code, Set xRg = Range("D1:J13") means move and place the chart into Range D1:J13. You can change the range as you need.
3. Press F5 key or click the Run button to run this VBA.
Now you will see the chart is moved to the precise position as you specified in the VBA. See screenshot:
An amazing tool to set absolute position of a chart in Excel
If you have Kutools for Excel installed, you can apply its amazing chart tool – Set Absolute Position of Chart to move and resize a chart to a specified range in Excel.
Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Free Trial Now!
1. Select the chart you that you will set absolute position, and click Kutools > Charts > Chart Tools > Set Absolute Position of Chart.
2. In the popping out dialog, specify the position that you will move the chart to, and click the Ok button.
Now the selected chart is moved the specified position, and resized to the specified range simultaneously. See screenshot:
Related articles:
Add a single data point in an Excel line chart In general, it’s easy to add two data series in one chart in Excel. But now, you need to add only one data point in an existing line chart in Excel, how to solve this problem? Below solution will ease your work.
Move chart with arrow keys in Excel In Excel, we can use the arrow (Up, Down, Left, Right) keys on the keyboard to move the picture, shape as quickly as you need. However, when moving the chart by using these arrows keys, it will not work well. This article, I will talk about an easy trick to finish this job in Excel.
Move chart X axis below negative values/zero/bottom in Excel When negative data existing in source data, the chart X axis stays in the middle of chart. For good looking, some users may want to move the X axis below negative labels, below zero, or to the bottom in the chart in Excel. This article introduce two methods to help you solve it in Excel.
Resize all charts or pictures in Excel quickly Lets say there are a lot of pictures or charts of varying size in a worksheet. And now you need to unify all of them to the same size. How do you deal with it? This article will show the tutorial to resize multiple charts or pictures simultaneously with same size easily.
Resize chart area/plot area/title in Excel Inserting a chart into Excel is a usual way to show the data more intuitional, but sometimes you may think the default size of the chart is small. For viewing more clearly, you can resize the chart area, plot area or title and so on in Excel.
Best Office Productivity Tools
Transform Hours into Minutes with Kutools for Excel!
Ready to supercharge your Excel tasks? Harness the power of Kutools for Excel - your ultimate time-saving tool. Streamline intricate tasks and glide through your data like a pro. Experience Excel at lightning speed!
Why You Need Kutools for Excel
🛠️ Over 300 Powerful Features: Kutools is packed with more than 300 advanced features, simplifying your work in over 1500 scenarios.
📈 Superior Data Processing: Merge cells, remove duplicates, and perform advanced data conversions – all without breaking a sweat!
⏱️ Efficient Batch Operations: Why put in extra effort when you can work smart? Import, export, combine, and tweak data in bulk with ease.
📊 Customizable Charts and Reports: Access a broad variety of additional charts and generate insightful reports that tell a story.
🗄️ Powerful Navigation Pane: Gain an advantage with the robust Column Manager, Worksheet Manager, and Custom Favorites.
📝 Seven Types of Drop-down Lists: Make data entry a breeze with drop-down lists of various features and types.
🎓 User-Friendly: A breeze for beginners and a powerful tool for experts.
Download Now and Soar Through Time with Excel!
Read More... Free Download... Purchase...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
Enable tabbed editing and reading in
Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
Open and create multiple documents in new tabs of the same window, rather than in new windows.
Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Read More... Free Download... Purchase...
