close

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;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()