在Excel工作表上圈出 [英] Circle on excel sheet

问题描述

我想在Excel工作表中绘制大圆圈。在其他10个圆圈后面的内侧的下一个小圆圈。然后从最外周的周边到最内周边的线被绘制。这些行将这些圆分为12.我需要在每个圆的这些部分写一些
的东西。

请帮帮我。

问候

解决方案

你不能在工作表中绘制圆或线，你只能创建形状。

子测试（）
 ActiveSheet.Shapes.AddShape msoShapeOval，97.8,48,110.6,107.4 
 ActiveSheet.Shapes.AddConnector msoConnectorStraight，134.4,25.8,294,120 
 End Sub 

由您来计算形状的坐标以模拟圆和线。

Andreas。

Hi,

I want to draw big circle in excel sheet. Next smaller circles in inner side one after other 10 circles. Then lines from periphery of outer most to the periphery of inner most to be drawn. These lines divides these circles in to 12. I need to write some thing in these parts of each circle.

please help me.

regards

解决方案

You can not draw circles or lines in a sheet, you can only create shapes.

Sub Test()
    ActiveSheet.Shapes.AddShape msoShapeOval, 97.8, 48, 114.6, 107.4
    ActiveSheet.Shapes.AddConnector msoConnectorStraight, 134.4, 25.8, 294, 120
End Sub

It's up to you to calculate the coordinates of the shape to simulate circles and lines.

Andreas.

这篇关于在Excel工作表上圈出的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！