如何在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...
