Inconsistent format in LINE chart tooltip

Occasional Contributor

Hi team,

 

We have created a LINE chart from the below data

PeriodsProducts$ value
week1COMPANY 1-$193M
week2COMPANY 2$31M
week3COMPANY 1 $19K
week4COMPANY 2-$312M
week1COMPANY 1-$163M
week2COMPANY 2$265M
week3COMPANY 1$165M
week4COMPANY 2-$272M

 

We have applied format in the $ value column
for positive number cells as -> [>999999]\$#,##0,,"M";[>999] \$#,##0,"K";\$#,##0
and for negative numbers as -> ##\$#,##0,,"M" based on the cell value.

data without formatting will look like 

PeriodsProducts$ value
week1COMPANY 1-193305001.4
week2COMPANY 230945602.86
week3COMPANY 119104.845
week4COMPANY 2-312312350.9
week1COMPANY 1-162850584.3
week2COMPANY 2265085524.4
week3COMPANY 1165275457.6
week4COMPANY 2-271548364



When we render the chart out of this data, we are seeing inconsistent formatting in the tooltip as below 

 

ThilakBabu_0-1665080409585.png

 

Could you please help us understand the inconsistent tooltip behavior in Excel ?

 

Note : I am unable to attach the excel here. Please let me know if any other info is needed.

 

Thanks,

Thilak Babu

2 Replies

@ThilakBabu 

I can reproduce it. It looks like a bug. You can report it from within Excel by selecting File > Feedback and clicking Send a Frown.

By the way, Data Labels display correctly formatted values:

S1833.png

Thanks @hans for confirming that it's a bug.
I provided the feedback with in the excel and attached this forum link.