I need vertical separators in a chart.

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

Frank Martin

I have Access2003 & 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 "yyyymm" 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

***
 
I'm sure there are more elegant ways to get a horizontal bar in a report,
but, in design view, I used the line tool in the tool box and inserted
vertical lines in detail and header sections between the fields I wanted to
separate. I had to "play" a bit with the height, weight & color of the line
to get a result that didn't lood too stark, but I liked the end result.
 
Frank:

There is no real way to create vertical separators. However, see if you can
either:

1.) Create a month value for your graph that has a 00 month. (you could do
this if you create a table with 00-12 in it, separate the month from the
year as a field and use an outer join from the table to the query that has
the actual months in it. This of course would create a bar with no value
but would you could fudge with the formatting to have it just display the
year.

2.) The Graph object itself does contain an option to set the spacing
between bars, but it changes the value for all bars rather than just one,
but you could play around with that to enhance the readability of the chart.

HTH
 
Thank you for replying.
I would like to fully understand the method you explain in (1), is this
like..

1/ Create a new table with one field "nullMonth".

2/ And then? Do I put a value in the field such as 200000 (zeroth month
2000) and use this?

3/ Why would I have to separate the year from the month?

Please help, Frank
 
Back
Top