访问图表 [英] Access Chart
问题描述
我希望绘制一些可疑的简单数据。
Project StartDate EndDate StartPoint EndPoint
No 1 7/4/2007 7/8/2007 5 12
No 2 9/12/2007 9/14/2007 9 14
等..
我想将开始日期和结束日期用作Y轴点，将起点和终点用作X轴点，并使用项目编号标记每个生成的矩形。结果图表将在x轴上重叠9到12的矩形。我已经看到了删除摘要的微软帖子，但没有一个图表对象似乎允许范围代表两个典型轴中的每一个上的每个记录。进一步：我还没有找到一个允许这个定义的对象。
感谢您提供任何链接或提示。
嗨
当我想要一个''简单''图表时，我最终绘制了矩形，通过乘以56，将cms中的高度设置为像素。
我只想显示12个值，所以我有Box0 thro Box11''预先绘制''并且只是在循环中改变了它们的高度。可以用代码改变它们的左和宽。
制作缩放和其他一些东西有点单调乏味但它给了它我正是我想要的。
如果你对这个apprtoach感兴趣我可以提供更多细节，但我承认，最后我觉得我重新发明了轮子！
S7
此时我没有其他线索，所以如果你有时间，我可以使用你所说的细节。
谢谢
嗨
当我想要一个''简单''图表时我最终得到了绘制矩形，通过乘以567将cms中的高度设置为像素。
我只想显示12个值，所以我有Box0 thro Box11''预先绘制''并且刚刚更改他们在一个循环中的高度。可以用代码改变它们的左和宽。
制作缩放和其他一些东西有点单调乏味但它给了它我正是我想要的。
如果你对这个apprtoach感兴趣我可以提供更多细节，但我承认，最后我觉得我重新发明了轮子！
S7
此时我没有其他线索所以如果你有时间，我可以使用你所说的细节。
谢谢
在我们开始之前错误的道路，您希望在图表中包含多少项目？考虑到代码的重复性，一个不错的数字大概是10，尽管如果你把时间放在代码中，代码可能会用循环来改进。但是太多的重叠矩形也可能令人困惑。
我的图表用于屏幕显示，但我想这些代码可以复制到报告中。
你能提供更多的数据吗？或者我会尝试用你发布的东西。一个问题是确定比例，因此在某些时候你必须确定数据值的范围，而两套可能不是公平的测试。
我现在正试着打破纳税截止日期，但我会明白是否能在明天找到时间。
S7
I am looking to chart some suspiciously simple data.
Project StartDate EndDate StartPoint EndPoint
No 1 7/4/2007 7/8/2007 5 12
No 2 9/12/2007 9/14/2007 9 14
etc..
I would like to use the start dates and end dates as Y axis points and start and end points as X axis points and label each resulting rectangle with the Project Number. The resulting chart would overlap rectangles from 9 to 12 on the x axis. I have seen the microsoft post on removing the summary but none of the charting objects seem to allow a range to represent each record on each of the two typical axis. Further: I have yet to find an object that will allow this definition at all.
Thank You for any links or tips.
Hi
When I wanted a ''simple'' chart I ended up drawing rectangles, setting Height in cms to pixels by multiplying by 567.
I only wanted to show 12 values, so I had Box0 thro Box11 ''pre-drawn'' and just changed their height in a loop. It would be possible to change their ''Left'' and ''width'' with code.
It was a bit tedious working out the scaling and a few other things but it gave me exactly what I wanted.
If you are interested in this apprtoach I can give more details but I admit that towards the end I felt I had re-invented the wheel!
S7
I have no other leads at this point so if you have a moment, I could use the details you spoke of.
Thanks
Hi
When I wanted a ''simple'' chart I ended up drawing rectangles, setting Height in cms to pixels by multiplying by 567.
I only wanted to show 12 values, so I had Box0 thro Box11 ''pre-drawn'' and just changed their height in a loop. It would be possible to change their ''Left'' and ''width'' with code.
It was a bit tedious working out the scaling and a few other things but it gave me exactly what I wanted.
If you are interested in this apprtoach I can give more details but I admit that towards the end I felt I had re-invented the wheel!
S7
I have no other leads at this point so if you have a moment, I could use the details you spoke of.
ThanksBefore we start off down a wrong road, how many ''projects'' are you hoping to include in the chart? Becaues of the repetative nature of the code, a nice number would be about 10, although code can probably be improved with loops if you put the time in. But too many overlaid rectangles could be confusing as well.
My chart was for a screen display although I imagine the code could be copied into a Report.
Can you supply a bit more data? or shall I try something with what you have posted . One problem is to determine the ''scale'' so at some point you must determine the ''range'' of the data values and two sets may not be a fair test.
I''m try to beat the Tax Deadline right now but I''ll see if I can find time tomorrow.
S7
这篇关于访问图表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
