Converting $3,000,000,000,000 to $3.0 on an Axis

[begexcel]

Hi,

I was wondering if someone could please tell me how to change this on the axis (i.e., format the axis) but leave the values unchanged in the table. Sorry if this has been addressed before. I didn't find it.

Thanks!

 

[dan_l]

depends on version, me thinks.


Right click on the axis, change display units to millions, billions, trillions, bajillions, and gazillions.

 

[begexcel]

Perfect. Thank you!