how do hoy show per million in a chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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
 
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????
Click to expand...

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.
 
I was half-asleep went I sent this - ignore the part about not with XY
chart!
 
Back
Top