I have a chart and the total amount of sales is showing on top of the chart in the middle.
the nr is wrong like I see now : 152147e+08!!
I tried the nr tab and set it as money ..nothing changed.
Anybody knows how to fix it or delete it..
In the nr tab use Million seperator M. Issue is because of huge length of the term. If you dont want a million seperator try increasing the column width.
Hope this helps,
I tried to use the Million and Billion seperator..Didnt work ..
How can I change the column width?
Hower mouse to the extreme right of the column you can see a cursor changes to something like '|'. Then hold left click and move.
Can you share the document if you arent able to do this?
I am sorry ..I just dont know which column is that.
I am working inside the chart...the only place the mouse cursor chamges is when I get to the borders of the chart so i can maximize it or minimize it!!
Thank you so much
My earlier post would work only for Straight or Pivot table. Is it possible to share a sample of your document?
I am sorry I cannot share..
I am not using tables..just a Chart
Can you share a screenshot of your problem?
try a Fixed to format like this: #########.##0
Remove symbol and place Millon and Thousand symbol. This would solve your problem.
Hope it may helps you
Retrieving data ...