UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Lock The Scale Of Graphs    
 
   
Ajazz
post Apr 2 2012, 02:15 AM
Post #1

UtterAccess Addict
Posts: 176
Hello Everyone

I have a "Lines on 2 Axes" chart in Access-Reports.

The Primary axis is formated as numbers, the secondary is percentage.

The goal I have is to make sure the maximum value should go beyond 25% on the secondary axis, no matter what set of data I was given.

But in my case, the garph changes and adjusts the scale automatically to 25 % - 7% - 72% - 100% - 120% etc. (depending on the data)

THANK YOU.

(MS ACCESS 2003)

This post has been edited by Ajazz: Apr 2 2012, 02:16 AM
Go to the top of the page
 
+
briangriffey
post Apr 3 2012, 12:00 PM
Post #2

UtterAccess Veteran
Posts: 312
From: Las Cruces, NM
In properties... under the "scale" tab... you can check the box next to the axis(s) in question... and then type in a fixed value. Then the auto-ranging will not take effect for that axis(s).
Go to the top of the page
 
+
arnelgp
post Apr 3 2012, 12:39 PM
Post #3

UtterAccess Ruler
Posts: 1,090
Hello Ajazz (IMG:style_emoticons/default/hat_tip.gif)
Go to the top of the page
 
+
Ajazz
post Apr 4 2012, 01:32 AM
Post #4

UtterAccess Addict
Posts: 176
THANK YOU Briangriffey !
Go to the top of the page
 
+
Ajazz
post Apr 4 2012, 01:33 AM
Post #5

UtterAccess Addict
Posts: 176
Hey Arnel.
Go to the top of the page
 
+
« Next Oldest · Access Reports · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 08:14 AM