MSACCESS-Piechart- legend -truncates zeroes

[baba]

My legend in the piechart has values like 004,008 etc but while the report is created,the legend has the preceding
0's truncated and 004 is shown as 4 and 008 is shown as 8. Is there a way to fix that and avoid removal of preceding zeros in the legend. Thanks for the help !

[TheSmileyCoder]

If you open the chart, you should be able to set the format property for the Legend object to text. Its likely currently set to General.

[baba]

Hello ,Thanks for your response. I am unable to change the format property of the legend object to text .I would really appreciate if you could explain me the steps involved. I dont see a format property for legend at all. Also even if I change the column to text in the datasheet and rerun the query,the legend does not show the leading zeros in the bargraph. Please advise

[TheSmileyCoder]

I dont have the greatest experience in charts, but last time I used it I simply double clicked the chart in my report, and it pretty much looked like it does in excel.

I can't tell you exactly where to click as I dont currently have any databases that includes charts, so I have no sample to work by.

[NeoPa]

Again, I have little experience (or interest) in Pie Charts, but I suspect it will have a control for showing the title whose properties can be maintained - probably graphically. Try going in to design mode and enlarging the control for the legend.

[baba]

I have no clue if there is an option to change the format of the legend to text .So I reformatted my data and prefixed my data with a colon and by that it forces the data as text and 0004 is written successfully as :0004 into the legend. There may be other solutions but this works...

[NeoPa]

Oh I see. If that's your problem (It was hard to understand what you were asking about until your latest post gave it away) then use formatting. If you haven't found the object then the better option of setting the object's Format property to "0000" won't help you much, but you can set the value to :

Format({YourValue}, "0000")