convert number to % using only custom number format challenge
Aha, that's exactly what I was looking for.
I multiplied my % values by 100,000 and plotted them directly,
removing the marker points and lines, but adding formatted data labels
using your custom number format. Lose some control over the position,
but adequate for my needs right now.
On Jun 2, 11:19*am, Ron Rosenfeld wrote:
You could multiply your percent figure by 100,000; and then use this custom
format:
0.0,\% *(to display with one decimal).
--ron
|