Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / January 2006

Tip: Looking for answers? Try searching our database.

I need vertical separators in a chart.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Frank Martin - 02 Jan 2006 01:15 GMT
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

***
NC_Sue - 02 Jan 2006 11:19 GMT
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.
Signature

Thanks for your time!

> I have Access2003 & WindowsXP and MSGraph2000.
>
[quoted text clipped - 22 lines]
>
> ***
Frank Martin - 04 Jan 2006 00:32 GMT
Thanks, this will work for some cases.
Regards, 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
[quoted text clipped - 31 lines]
>>
>> ***
SA - 03 Jan 2006 02:47 GMT
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
Signature

Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

>I have Access2003 & WindowsXP and MSGraph2000.
>
[quoted text clipped - 23 lines]
>
> ***
Frank Martin - 04 Jan 2006 00:32 GMT
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

> Frank:
>
[quoted text clipped - 41 lines]
>>
>> ***
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.