Graph Axis Million and Thousand

[shansakhi]

Hello,
Hope all are fine and safe.
I need your assistance for below.
I always come across a situation where I have a few Revenue Numbers in Millions Unit, a Parts number inn Thousand Unit and Rate is in normal unit.
Currently while creating the graph I use secondary access for Rate numbers but for Millions and Thousand Unit, no choice but I have to use only axis. Due this my thousand number bar in graph shows either a thin line or invisible.
Can you please assist me to play with Axis where I can show Revenue Numbers in Millions , Part Numbers in Thousands and Fare in Normal and all visible properly.

Year	Revenue (mn)	Parts (k)	Rate
2019​	7.2	96.9	74.5
2020​	1.4	13.5	104.2

Please Assist.

Thank you
Shan

 

[denzo36]

If you select the axis which contains the number you want to format and hit CTRL+1 to format the axis, you have the option to show the axis on a logarithmic scale as per below which should enable you to show all values on the one axis

 

[pgc01]

Hi

I'm not a fan of posting several series referring to different things, may get confusing, but to answer the question...

With the values you posted I'd use revenue in one axis and both rate and parts (divided by 1000) in the other axis.

You'd have for the second axis the ranges 13.5-96.9 and 74.5-104.2 which would display all right in the 0-120 axis

You can add the axis title "Rate / Parts (k)" to make it clear that parts are in thousands.

As I said, it may be somehow confusing.
Another option is for ex. to make 3 charts and display them side by side.

 

[shansakhi]

If you select the axis which contains the number you want to format and hit CTRL+1 to format the axis, you have the option to show the axis on a logarithmic scale as per below which should enable you to show all values on the one axis

View attachment 24466

Thank you ... This works for me.

 

[shansakhi]

Hi

I'm not a fan of posting several series referring to different things, may get confusing, but to answer the question...

With the values you posted I'd use revenue in one axis and both rate and parts (divided by 1000) in the other axis.

You'd have for the second axis the ranges 13.5-96.9 and 74.5-104.2 which would display all right in the 0-120 axis

You can add the axis title "Rate / Parts (k)" to make it clear that parts are in thousands.



View attachment 24476


As I said, it may be somehow confusing.
Another option is for ex. to make 3 charts and display them side by side.

This is also a good way to showcase but little confusing as you correctly mentioned. Thank you for your assistance.

 

[denzo36]

Thank you ... This works for me.

No problem!