Number formatting in chart

G

Guest

The secondary axis in my chart is dollar value. It is showing in thousands,
which is what I want, but the data labels I would like it to show 177 only,
for example, instead of 177,883. It would be understood that the labels are
in thousands. Is this possible? Connie
 
G

Guest

Okay, I guess I didn't make myself very clear. I will try to take a
different approach. How do I customize the format of numbers in a column so
that it rounds 177,883 to 178? Connie
 
G

Guest

Okay, folks! Never mind. It is "#," to format 177,883 to 178. And then the
data labels will show only the "#," numbers, and you can format the axis to
show 1000's with three zeroes. Thank you Excel Help! Connie
 

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

Similar Threads

Display Horizontal and Vertical Line In Area Chart (Excel 2007) 2
Inside Base Series Label Showing #N/A 0
Retaining Formatting in 'joined' cells 2
Chart w/Secondary Axis 1
Changing the data label position below the chart axis. 2
Line Chart - Problems with labeling X-Axis 3
Text-wrapping horizontal axis labels 4
Pivot chart series label 1

Top