how do hoy show per million in a chart

A

Arnout

I want to get rid of all the zero's in my chart, meaning no more 10.000.000
but just 10.............. How do I do this, without dividing my hole sample
through 1.000.000????
 
B

Bernard Liengme

For a Line or Column chart (but not an XY chart): format the axis and on the
Scale tab use the Display Units feature.
best wishes
 
D

Del Cotter

I want to get rid of all the zero's in my chart, meaning no more 10.000.000
but just 10.............. How do I do this, without dividing my hole sample
through 1.000.000????

For any numbers, use a custom number format like this:

0,,

The two commas will suppress the display of the lowest six digits of
your numbers, without affecting the actual numbers as they are stored in
the cell.
 
B

Bernard Liengme

I was half-asleep went I sent this - ignore the part about not with XY
chart!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top