cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

clustered column chart settings

Hi,

Using the clustered column chart visual as follows:

y axis shows M which I know is short for Millions. i.e. 0M, 1M, 2M, 3M, as well as -3M, -2M, -1M

Question:

1- 

How can I convert smaller numbers to show 100K, 200K, etc. instead of 0.1M, 0.2M, etc.?

2-

How can I add a label to the axis i.e. $  ?

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: clustered column chart settings

Hi @Anonymous ,

 

For your first question, the units of y axis must be the same(either thousands or millions).
For your second question, you can change the format of data to currency.

Best Regards,

Eads

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Re: clustered column chart settings

Hi @Anonymous ,

 

For your first question, the units of y axis must be the same(either thousands or millions).
For your second question, you can change the format of data to currency.

Best Regards,

Eads

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors