Solved

Pivot Chart 100 thousand annoying axis decimals

Posted on 2009-03-31
14
1,711 Views
Last Modified: 2013-11-28
I have a pivot chart that can not  make it to stay in the value axis I set. Every time I get it to show whole numbers after I closed it and open it again, it shows the .....en axis the same way again!
I've try all the combination way to show single whole number and can make it stay that way.
What is the secret? is it the table field data type value?
Advice please.
untitled.bmp
0
Comment
Question by:Exl04
14 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 24036554
If the data is showing a count I wouldn't have expected to have to set the axis properties at all.
Arte you saying that if you remove all the ticks from the scale tab this is what you get?
0
 
LVL 28

Expert Comment

by:TextReport
ID: 24036598
If you select the axis and then Property Sheet, Format, Number: You can select the standard formats such as STANDARD and FIXED which default to 2 decimal places or you can enter a custom format such as #,##0 then goes to ZERO decimals
Cheers, Andrew
1
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24037896
Exl04,

Is there a specific reason why you are using a Pivot Chart instead of a standard chart?

I used a standard chart, and like Andrew, I was able to set the Axis Number format to:
Fixed, 2 decimal places

The chart functions without a hitch

Screenshot and sample attached.

JeffCoachman
Access-EEQ24283274-ChartGraphAcc.mdb
untitled.JPG
0
 
LVL 1

Author Comment

by:Exl04
ID: 24039239
peter57r:
Is what I thought, but if I remove the axis, then I can set up the labels for the series, it doent give an option in this Pivot chart.
TextReport:
This is a pivot chart and it does have some options to set up the axis, but that my problem when I set it and save it, after I closed it and open it, it opens the same way with all the .00000000000s.
boag2000:
Yes, I need a pivot chart. I have a dashboard and in the same from already got to more charts. I need the Pivot chart so I dont get the dashboard crowed with lots of chart, this way I show the 2 most important charts and with all the data I let them Build their own other needed chart with the Pivot Chart.

I'm willing to remove the axis if I can show series values.

Attached a sample.

Database2.mdb
0
 
LVL 28

Expert Comment

by:TextReport
ID: 24039328
I have just opened my test form and the format of the axis is still set to #,##0, this is opn a PivotChart in Access 2007. Can you double check that the save is working and that there are no events that are triggering causing a problem.
Cheers, Andrew
0
 
LVL 28

Expert Comment

by:TextReport
ID: 24039369
Just tried your PivotChart form, modified the axis format,saved the form and the next time I opened it it was OK.
Cheers, Andrew
0
 
LVL 28

Expert Comment

by:TextReport
ID: 24039445
There is a more fundamental issue with the graph and probably is related to the problem with the axis, the first bar is not showing as 9 but is slightly below as is the 3rd bar that should be 8.
Cheers, Andrew
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 1

Author Comment

by:Exl04
ID: 24039476
So I have so save setting wrong? where can I check. or when you changed the axis properties did you just closed the form and open it? or is there a other way to be sure is save.
0
 
LVL 28

Expert Comment

by:TextReport
ID: 24039538
I forced a save through the save button at the top of the screen next to the office icon.

I have been into the PivotChart and the Pivot table and the data in the PivotTable is correct at 9, 1 and 8.
I think the issue with the PivotChart is possibly a cosmetic 1 where the bar doesn't touch the gridline, however, this is certainly caused by the major grid lines not being at the correct unit but not sure why.

Cheers, Andrew
0
 
LVL 28

Expert Comment

by:TextReport
ID: 24039560
I set the Custom Max to 10 then unticked it and this has put the gridline back and no doubt fixed the actual axis.
Cheers, Andrew
0
 
LVL 28

Accepted Solution

by:
TextReport earned 500 total points
ID: 24039587
What I don't understand though is why the Custom Max wa at such an obscure number 10.054299011128 but setting this to 10 sorted the issue. You still need to use the Format of #,##0 though to get rid of the decimals.
Cheers, Andrew
0
 
LVL 1

Author Comment

by:Exl04
ID: 24043604
TextReport, thanks for the input.. I've been busy all morning and havent seen you  post.
On tha saving, I did that forced Saving too and when I open it again the decinals are there.
i can not set the Max to 10 because the chart may have values above 10. I need all to be Automatic
Where do I use this format? the chart doent give that option?
0
 
LVL 1

Author Comment

by:Exl04
ID: 24043614
I got it now.
I used the formatting suggestion and it fixed!
Thanks!
0
 
LVL 1

Author Closing Comment

by:Exl04
ID: 31565131
One more knowledge tool on my toolbox thanks to you!
Thanks!!
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now