software

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

***
Apparently, Frank Martin of Australia and Peter Jason of New Zealand
have the same query -- word for word.

--
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;

What sharp little eyes you have!quot;Tushar Mehtaquot; gt; wrote in message om...
gt; Apparently, Frank Martin of Australia and Peter Jason of New Zealand
gt; have the same query -- word for word.
gt;
gt; --
gt; Regards,
gt;
gt; Tushar Mehta
gt; www.tushar-mehta.com
gt; Excel, PowerPoint, and VBA add-ins, tutorials
gt; Custom MS Office productivity solutions
gt;
gt; In article gt;,
gt; says...
gt;gt; I have Access2003 amp; WindowsXP and MSGraph2000.
gt;gt;
gt;gt; *****
gt;gt;
gt;gt; I have many charts based on MSGraph using xtab queries as the sources.
gt;gt;
gt;gt; All works well except for one small problem.
gt;gt;
gt;gt; Since I have all data shown monthly for over 7 years, this adds up to a
gt;gt; pretty dense chart, which is excellent for discerning trends.
gt;gt;
gt;gt; (The X axis is always the quot;yyyymmquot; one.)
gt;gt;
gt;gt; Now what I need is a simple VERTICAL separator (rising from the X axis)
gt;gt; on
gt;gt; the chart to separate the years in either calendar or financial years.
gt;gt;
gt;gt; The Y axis has these built in and their separation can be adjusted.
gt;gt;
gt;gt; Why not for the X axis?
gt;gt;
gt;gt; Can someone help me to insert such separators, or is there 3rd-party
gt;gt; software to do this?
gt;gt;
gt;gt; Please help, Frank
gt;gt;
gt;gt; ***
gt;gt;
gt;gt;
gt;gt;