Microsoft Access 2007 图表空间帮助
我有一个带有默认图表视图的表单。该表单作为子表单加载，数据由父表单动态过滤。它看起来比使用图表对象要好得多（当表单缩放图表对象时，它看起来非常糟糕）。
我的问题是这样的。我已经能够找到关于 chartspace 对象模型的很少信息，这似乎是务实地修改底层表单的方法，我可以更改线条颜色和标记颜色，但需要找出如何删除折线图中的连接线并更改单个标记的颜色。这就是我到目前为止所拥有的：
Private Sub Form_Load()
Dim XChart as Object
set XChart = Me.ChartSpace.Charts(0)
With XChart.SeriesCollection(0)
.interior.color = vbBlue
.line.color = xlNone ' This does not work, it makes a light blue color line
.line.weight = 0 ' still shows a thin line
End With
任何有关 Office 2007 的文档都会非常有帮助，我已经搜索了几个小时，只能在 MSDN 上找到一页，基本上在 OM for ChartSpace 上什么也没说。有一些 2000/2003 OWC 组件示例可以帮助我到目前为止，但无法让我更进一步，显然 OWC DLL 在 Office 2007 中也已被淘汰。
I have a form with a default view of a chart. This form is loaded as a subform, the data is dynamically filtered by the parent form. It comes up and looks way better than using a chart object (when the form scales the chart object it looks really bad).
My question is this. I have been able to find little information on the chartspace object model which appears to be the way to pragmatically modify the underlying form, I can change the line colors and marker colors but need to find out how to remove the connecting line in a line graph and change a single markers color. This is what I have so far:
Private Sub Form_Load()
Dim XChart as Object
set XChart = Me.ChartSpace.Charts(0)
With XChart.SeriesCollection(0)
.interior.color = vbBlue
.line.color = xlNone ' This does not work, it makes a light blue color line
.line.weight = 0 ' still shows a thin line
End With
Any documentation on this for Office 2007 would be very helpful, I have been searching for hours and can only find one page on MSDN that basically say's nothing on the OM for ChartSpace. There are a few 2000/2003 OWC component examples which have been able to get me this far but not able to take me any further, apparently the OWC DLL was phased out in Office 2007 also..
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
使用 Excel 2010 宏记录器，我能够公开执行此操作所需的 VBA 代码，以前版本的 Office 没有记录处理此任务的代码。
Using the Excel 2010 Macro Recorder I was able to expose the VBA code needed to do this, previous versions of Office did not record the code that would take care of this task.