Exl04
asked on
Pivot Chart 100 thousand annoying axis decimals
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
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
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
Cheers, Andrew
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
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
ASKER
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
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
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
Cheers, Andrew
Just tried your PivotChart form, modified the axis format,saved the form and the next time I opened it it was OK.
Cheers, Andrew
Cheers, Andrew
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
Cheers, Andrew
ASKER
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.
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
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
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
Cheers, Andrew
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
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?
ASKER
I got it now.
I used the formatting suggestion and it fixed!
Thanks!
I used the formatting suggestion and it fixed!
Thanks!
ASKER
One more knowledge tool on my toolbox thanks to you!
Thanks!!
Thanks!!
Arte you saying that if you remove all the ticks from the scale tab this is what you get?