[AccessD] Friday Puzzler - Only Integers on X Axis on Graph

Dan Waters df.waters at comcast.net
Fri Sep 3 15:17:55 CDT 2010


Great!

I do like graphs in Access (MS Graph).  Once you get the data source right,
the rest is a lot like making a chart/graph in Excel.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Friday, September 03, 2010 2:58 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Friday Puzzler - Only Integers on X Axis on Graph

Dan,

Thanks for the tip - works great.

I appreciate the assistance.

Brad

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Friday, September 03, 2010 3:01 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Friday Puzzler - Only Integers on X Axis on Graph

Hi Brad,

With the chart in Edit mode, right click on the axis, and select Chart
Options (I think).  Then select the Axis tab, then uncheck Auto for the
Major interval, then enter the major interval that you want the axis to
display.  It's very similar to Excel.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Friday, September 03, 2010 2:49 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Friday Puzzler - Only Integers on X Axis on Graph

Is there a way force the scale of the X Axis of an Access 2007 graph to
only show integers.

 

The items that I would like to graph are always whole numbers.  (1.5
parts is confusing)

 

Thanks,

Brad

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list