Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Access 2007 pivot chart, set y-axis number format to integer

 
   Database Help (Home) -> MS Access RSS
Next:  Code to open a query  
Author Message
MStoddard

External


Since: Dec 12, 2008
Posts: 1



(Msg. 1) Posted: Fri Dec 12, 2008 4:57 pm
Post subject: Access 2007 pivot chart, set y-axis number format to integer
Archived from groups: microsoft>public>access (more info?)

Can one set the pivot chart y-axis number format in Access 2007 to integer?
If so, how?

I'm charting homicides; it does not make sense to display numbers after the
decimal point.

Thanks,

Michael

 >> Stay informed about: Access 2007 pivot chart, set y-axis number format to integer 
Back to top
Login to vote
MStoddard

External


Since: Dec 12, 2008
Posts: 1



(Msg. 2) Posted: Fri Dec 12, 2008 5:11 pm
Post subject: Re: Access 2007 pivot chart, set y-axis number format to integer [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Dec 12, 11:57 am, MStoddard
wrote:
> Can one set the pivot chart y-axis number format in Access 2007 to integer?
> If so, how?
>
> I'm charting homicides; it does not make sense to display numbers after the
> decimal point.
>
> Thanks,
>
> Michael

I should mention that I know how to set custom minor and major units,
and min and max. So I can get one chart's y-axis to display integer
values. What I want to do is set the y-axis format to integer so that
I can explore my data set via pivot charts without having to reset the
units and min and max for different crimes (I'm working with crime
data). I hope this makes some sense.

 >> Stay informed about: Access 2007 pivot chart, set y-axis number format to integer 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Pivot Chart question Access 2007 - I am expanding an Access 2007 db for maintenance agreement customers in my heating and air company. One of the charts i am trying to capture is the number of 1st time visits by quarter going back to the 1st qtr of 2006. This is also referred to as the...

Access Chart with a secondary Y Axis - Hi all Does anyone know if it's possible to get a secondary y-axis in Access charts? I have two series of numbers. One averages around 2.0 and the other around 50 (both measured against time) e.g. Jan07 1.8 48.7 Feb07 1.9 50.4 Mar07 1.9 49.8..

Access Pivot Table and Pivot Chart - I have a pivot table that has calculated fields (by Row and or Column) and every time I try to view as a pivot chart it reverts back to the count not the calculated field. Can this be done and if so how. Thanks for your help. (this is in access 2003) ..

Problems With X Scale Number Format In Chart - I am charting data from a query that consists of a Date/Time field and a Number field. The Date/Time field is the x scale on my chart. Sometimes data is collected from different times during the one day. I need to be able to see these times as..

Pivot Chart/Report Help - Microsoft Access 2003 - I need some serious help here. I've been trying to figure this one out for 3 days now and I'm getting nowhere. I've searched google extensively for anyone else that might have been having this issue but come up with nothing. OK, I have a very simple..
   Database Help (Home) -> MS Access All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]