在Excel折线图中隐藏数据点 [英] Hiding data points in Excel line charts

问题描述

显然可以在Excel折线图中隐藏单个数据点。

It is obviously possible to hide individual data points in an Excel line chart.

• 选择一个数据点。


• 右键单击->格式化数据点...


• 选择模式


• 将制表符设置为无

• Select a data point.
• Right click -> Format Data Point...
• Select Patterns
• Tab Set Line to None

您如何在VBA中完成相同的工作？直觉告诉我点对象 Chart.SeriesCollection（< index>）。Points（< index> 处理这个问题...

How do you accomplish the same thing in VBA? Intuition tells me there should be a property on the Point object Chart.SeriesCollection(<index>).Points(<index> which deals with this...

推荐答案

几乎每次都描述为泰迪熊 ...

"Describe it to the teddy bear" works almost every time...

您必须转到边界Point对象的子对象，并将其LineStyle设置为xlNone。

You have to go to the Border child object of the Point object and set its LineStyle to xlNone.

这篇关于在Excel折线图中隐藏数据点的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！