Changing format in data table below chart object (1 Viewer)

C

CNorway

Registered User.

Local time

Today, 11:25

Joined

Feb 13, 2018

Messages

33

• Aug 31, 2018

• #1

Hi,

I have a chart object with a data table below the chart. I want the revenue figures in the table to be in "standard format" or "# ##0".

Currently they are showing figures like: "4036" and I want "4 036".

I found I can edit the object by right clicking on it and then making it the correct format. However, after saving and coming back to the chart object, the numbers revert back to "4036". Any idea?

Thanks,
Chris

 

I

Insane_ai

Not Really an A.I.

Local time

Today, 14:25

Joined

Mar 20, 2009

Messages

264

• Aug 31, 2018

• #2

This format works for me in the debug window

Code:Copy to clipboard

debug.Print Format("4096","# ##0")
4 096

Maybe this article will help a bit more....
https://support.office.com/en-us/article/Specify-how-data-displays-by-using-custom-formatting-A5E5BCDE-85DA-4C7A-8164-1FE286636668#bm2

 

C

CNorway

Registered User.

Local time

Today, 11:25

Joined

Feb 13, 2018

Messages

33

• Sep 1, 2018

• #3

OK. I see that the formatting isn't done on the table object itself (like I do on the graph object). So, by using the format function in the query for the chart, it solves the issue. Thanks.

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Tomorrow, 02:25

Joined

May 7, 2009

Messages

19,229

• Sep 1, 2018

• #4

you can also uze the format Property of your query in design view.