格式化图表 [英] Formatting Charts
问题描述
我有一个我建立的联合查询,以便我可以包括位置平均值和公司平均值。然后我对图表上的信息进行排序,使其最低到最高,所以现在公司平均值位于该组的中间位置。这可以直观地显示位置与公司的比较。问题是,我希望公司成为一个不同的颜色,因此它脱颖而出。我知道如何手动更改它,但由于公司平均值可以从一个季度移动到另一个季度,我想使用标准,我可以说,如果corp使数据点变成深蓝色。这甚至可能吗?如果是这样我怎么做?
I have a union query that I built so that I can include location average along with corporate average. I then sort the info on the graph so it is lowest to highes, so now the corporate average sits amongst the middle of the group. This givs a visual to where the locations compare to corporate. The problem is, I want the corporate one to be a different colo so it stands out. I know how to change it manually, but as the corporate average can move from quarter to quarter, I would like to use something like criteria where I can say if corp make datapoint dark blue. Is this even possible? If so how would I do this?
推荐答案
@rcollins
@rcollins
- 首先,设置对Microsoft Graph XX.X对象库的引用。
- 为SeriesCollection集合(系列对象)的特定成员设置内部对象的颜色属性:
- First, set a Reference to the Microsoft Graph XX.X Object Library.
- Set the Color Property of an Interior Object, for a specific Member of the SeriesCollection Collection (Series Object):
@rcollins
对不起rcollins,但你可以在之前的帖子中删除步骤#1,因为不需要这个引用。
@rcollins
Sorry rcollins, but you can elimate Step #1 in the prior Post since this Reference is not needed.
ok,所以我的图表是Graph2,我的x轴是CountyOfSurvey和Y轴是Expr1。 "公司"在CountryOfSurvey中始终是值之一,这是我想要的深蓝色。我假设我把它放在graph2下的VB编辑器中?你能帮忙确保我的代码正确吗?
ok, so my graph is Graph2, my x axis is CountyOfSurvey and Y axis is Expr1. "Corp" is always one of the values in CountyOfSurvey, this is the one I want to be dark blue. I am assuming I put this in the VB editor under graph2? Can you help to make sure I get the code right?
这篇关于格式化图表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!