Chart doesn't show rounded values

[mottebelke]

I have a pivot table in which a measure with the double datatype is
added. I formatted it using .NumberFormat = "#". So now it just shows
the rounded value.
On the same page there is also a column chart. It is linked to the
pivot table and shows the measure from that table.
But the values in the chart are the decimal values, not the rounded
ones. How can I display the rounded values in the chart as well?

 

[Alvin Bruney [Microsoft MVP]]

You may need to handle the export event and impose the formatting when the
chart renders. I believe you can also use the onfinale render event as well.

--
Regards
Alvin Bruney
[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc