I have Access2003 amp; WindowsXP and MSGraph2000.
*****
I have many charts based on MSGraph using xtab queries as the sources.
All works well except for one small problem.
Since I have all data shown monthly for over 7 years, this adds up to a
pretty dense chart, which is excellent for discerning trends.
(The X axis is always the quot;yyyymmquot; one.)
Now what I need is a simple VERTICAL separator (rising from the X axis) on
the chart to separate the years in either calendar or financial years.
The Y axis has these built in and their separation can be adjusted.
Why not for the X axis?
Can someone help me to insert such separators, or is there 3rd-party
software to do this?
Please help, Frank
***
Consider adding major gridlines for the x-axis.
And, please pass on the answer to Frank Martin of Australia who asked
the exact same question as you.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article gt;,
says...
gt; I have Access2003 amp; WindowsXP and MSGraph2000.
gt;
gt; *****
gt;
gt; I have many charts based on MSGraph using xtab queries as the sources.
gt;
gt; All works well except for one small problem.
gt;
gt; Since I have all data shown monthly for over 7 years, this adds up to a
gt; pretty dense chart, which is excellent for discerning trends.
gt;
gt; (The X axis is always the quot;yyyymmquot; one.)
gt;
gt; Now what I need is a simple VERTICAL separator (rising from the X axis) on
gt; the chart to separate the years in either calendar or financial years.
gt;
gt; The Y axis has these built in and their separation can be adjusted.
gt;
gt; Why not for the X axis?
gt;
gt; Can someone help me to insert such separators, or is there 3rd-party
gt; software to do this?
gt;
gt; Please help, Frank
gt;
gt; ***
gt;
gt;
gt;
- Apr 13 Sun 2008 20:43
Need vertical separators rising from the X axis.
close
全站熱搜
留言列表
發表留言